![]() When you create the custom number formats, paste in the symbols, and don’t enter the other characters. TIP: If you want the number in black font, show the icons in separate cells, that are linked to the score cells. The 9, in cell B3, is at the far right of the cell, and lines up with the final digit in the 100, in cell B6. Because we used the question mark characters, the digits line up correctly. The Completed FormattingĪfter you’ve applied the formatting, the icons will appear to the left of the number in column B, separated by a space. Repeat the steps for the other two symbols, then close the Conditional Formatting window. Click OK, twice, to close the Conditional Formatting windows.The preview will show the formatting, with the icon.On the Font tab, select Green as the font colour, then click OK.Click the Format button, and on the Number tab, select the custom format – ○ ?0.TIP: Make sure that the first reference is to the active cell – B2 in this example ![]()
0 Comments
Leave a Reply. |