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.

"Ruby Pro" wrote in message
...
I don't follow. Can you help me out with how I would write this formula?

"Max" wrote:

This set of CF formulae should work fine for you
Amounts monitored are assumed in A2 down

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

Success? hit the YES below
--
Max
Singapore
---
"Ruby Pro" wrote:
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.