Conditional format - 3 traffic lights
 

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

Conditional format - 3 traffic lights
 

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!*


"James" wrote:

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

Conditional format - 3 traffic lights
 

This worked! Thank you!

"Luke M" wrote:

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!*


"James" wrote:

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