Selected Answer
Ajazuddin
Not sure if this is what your want but the attached file has conditional formatting for cell G9 (right of yellow filled cell F9).
As you change the value, the dot in the cell will change colour. The colours don't match what you show in D8:D11 but are something like. You could just show the icon (by checking an option in the conditional formatting dialog).
I did that applying conditonal formatting to G9 as follows. Right click cell, pick Conditional formatting... then:
- change Icon Style: to pick the one with four icons, say the spots- grey, red, yellow and green )
- change the Type (on right) so each reads Number
- set values from top to (>=) 3, 2,1 and 0
- pick an icon for your colours (use Down arrow by Icon and select).
If you really want to swap icon sets (rather than icons), you'll probably need to use VBA (and I'd rather go for inserting a shape in the cells rather than swap icon sets).
Hope this helps.