Use the Formula Is option.

Let's assume you're dealing with cell A1.

Condition 1 - GREEN
=A1=17

Condition 2 - YELLOW
=AND(A1=15.3,A1<=18.7)

Condition 3 - RED
=OR(AND(A1<"",A1<15.3),AND(COUNT(A1),A118.7))


--
Biff
Microsoft Excel MVP


"JICDB" wrote in message
...
Nothing here answeres my question so I was hoping someone could help.

For example I have a cell that uses lookup formulas to grab a performance
indicator from another spreadsheet. I want the cell to change in the
following manor:

if cell equals the goal of 17 - background turns green
if cell is within 10% of 17 (above or below but not equal to 17) - turn
yellow
if cell is beyond that 10% (greater than 10% above or below but not equal
to
17) - turn red.

I couldn't get it to work so I just started with the first condition and I
have a cell that equals 17 exactly but does not turn green. If I type 17
over the formula whose result is 17 the cell does turn green. What am I
doing wrong? Is it the difference between "Formula is" and "Cell Value
is"?
What should the formulas be to make this stop light coloring work?

Thanks again for all your help.