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
|