Conditional Formatting using Traffic Lights

  • Thread starter Thread starter Ruby Pro
  • Start date Start date
R

Ruby Pro

Would like to set up conditional formatting where I can show a green light
for amounts above 0%, yellow light for below 0% but greater than -5%, and red
for anything below negative 5%. Appreciate your help.
 
This set of CF formulae should work fine for you
Amounts monitored are assumed in A2 down

Green
=AND(ISNUMBER($A2),$A2>0)
Yellow
=AND($A2<>"",$A2<=0,$A2>-5%)
Red
=$A2<-5%

Success? hit the YES below
 
The 3 formulas are all given clearly in my response? You simply apply it in
the CF using "Formula Is" as conditions 1, 2, 3 (it can be placed in any
order as the checks are mutually exclusive, no overlaps, no gaps). The
colour indicated is what you would then choose as the trigger format. This
formulas route is the nuts and bolts way of getting it done, and it'll pay
you dividends to grasp it.
 
Back
Top