View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
James James is offline
external usenet poster
 
Posts: 542
Default 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