Conditional Formatting using Traffic Lights

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.
 
M

Max

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
 
M

Max

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting with dates 7
CREATING NEW OR ADDING ICON SETS FOR CONDITIONAL FORMATTING 0
Excel 2007 Traffic Light with dates 6
Conditional format - 3 traffic lights 2
To find Maximum value using conditional formatting 2
Conditional formatting with two columns 0
Writing Formula For conditional Formatting Using Excel 2000 3
change icon color traffic lights in conditional formatting 1

Top