Create Colored Shapes:

You can use Excel conditional formatting and the Wingding font to create coloured shapes in a cell. In this example, coloured shapes will appear in cells C3:C7, depending on the value in the adjacent cell in column B. If the value is less than 10, a red circle will appear, if the value is greater than 30, a green square will appear. Otherwise, a yellow diamond will appear.
1. In cell C3 enter the formula:
=IF(B3="","",IF(B3<10,"l",IF(B3>30,"n","t")))
2. Copy the formula down to cell C7
3. Format cells C3:C7 with Wingding font, and yellow font color
4. Select cells C3:C7
5. Choose Format|Conditional Formatting
6. From the first dropdown, choose Formula Is
7. For the formula, enter: =$B3<10
8. Click the Format button, and select Red as the font colour, then click OK.
9. Click the Add button, and for Condition 2, choose Format|Conditional Formatting
10. From the first dropdown, choose Formula Is
11. For the formula,enter: =$B3>30
12. Click the Format button, and select Green as the font colour, then click OK.
13. Click OK