Conditional format - 3 traffic lights

[James]

I'm attempting to format using the 3 traffic lights but seem to have an error
using a negative number as a percentage.

Here is what I am looking to do:
For cells >= 0%, green traffic light
For cells <0% but >= -5%, yellow traffic light
For cells <-5%, red traffic light

Any help is greatly appreciated. Thanks!
James

 

[Luke M]

Your conditions here look good. Are you possibly attempting to enter them as
a formula? The simpler method is under condition format, change first box to
"cell value is" second box to "greater than or equal to", and type 0%
Second condition, change second box to "less than" and type -5%
third condition, second box "between" and type 0% and -5%

Note that you don't have to worry about overlap, because XL cares more about
the order of the conditions.

 

[James]

This worked! Thank you!

Your conditions here look good. Are you possibly attempting to enter them as
a formula? The simpler method is under condition format, change first box to
"cell value is" second box to "greater than or equal to", and type 0%
Second condition, change second box to "less than" and type -5%
third condition, second box "between" and type 0% and -5%

Note that you don't have to worry about overlap, because XL cares more about
the order of the conditions.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*