Conditional Formatting %%%%%

[pmw19800]

Hello

Please see attached
In B1 for example i want to use the traffic light icons

above =>90% = green
below <90% = Red


Any help would be great

[Richard Buttrey]

There doesn't appear to be a 2 traffic light icon set.

You'll have to either add a middle traffic light or choose something else.

[pmw19800]

above 90% = Green
middle 85% - 80 = orange
below 85 = red

would that work

[Richard Buttrey]

above 90% = Green
middle 85% - 80 = orange
below 85 = red

would that work

I think you mean above 90% red, between 80% & 90% orange, and below 80% red.

Make sure you enter .9 and .8 in the relevant boxes and choose 'Number' not 'Percent'.