Conditional Formating Help

[Excel15]

Ok I have a box that is uses the icon set (stoplight- Red, green, yellow). Is there a way to edit the color of these circles? It's supposed to be the color of a stoplight but the yellow and green (especially the yellow) is really a dull color of yellow and green. I can't seem to find a way to change the color of these icons (if there is a way).

Any help would be much appreciated I've attached an example.

Thanks!

[JieJenn]

The only thing you can change is the icons. One alternative is use Wingdings font (character l) and incorporate with conditional formatting using formula.

[Excel15]

That would work, but I'm not sure how you would incorporate with conditional formatting using a formula? So basically I wanted the circles to be red if the score to the right was 0, yellow if 1 and green if 2. Would you kindly show me an example of how you would incorporate this using a fromula. My goal is to make this as automated as possible because my boss had been inserting individual shapes to do it which was very time consuming.

Thanks!

[AliGW]

In the attached you will find three CF rules applied to the range:

=I5=0 (text set to red)
=I5=1 (text set to amber)
=I5=2 (text set to green)

Hope this helps.