Conditional format - another cell
 

How exactly is this done?

I am trying to format a cell (A20) if cell (B20) is within ranges
<0 = red
0-5 = orange
5 = green

I am trying to do this across 75 values and I don't want to go in & program
each cell independently. That would take forever.

I have seen some information on "Formula Is" but that appears to be an Excel
2003 feature and I've been unable to find the right way to do this in Excel
2007.

Help!!!!!?!?!?!!

Conditional format - another cell
 

I am trying to do this across 75 values

I don't know what that means.

Here's how you can do this:

I am trying to format a cell (A20) if cell (B20) is within ranges
<0 = red
0-5 = orange
5 = green

Select cell A20

Goto Home tabStylesConditional FormattingManage Rules

Click New RuleUse a formula to determine...
Format values where this formula is true:
=B20<0
Click the Format button
Select the desired style(s)
OKOK
Click New Rule again and repeat the above proccess for the second and third
conditions. Use these formulas:
Condition2: =AND(ISNUMBER(B20),B20=0,B20<=5)
Condition3: =AND(ISNUMBER(B20),B205)

Then, after you've set the third condition format: OKOKApplyOK


--
Biff
Microsoft Excel MVP


"CT" wrote in message
...
How exactly is this done?
I am trying to format a cell (A20) if cell (B20) is within ranges
<0 = red
0-5 = orange
5 = green


I am trying to do this across 75 values and I don't want to go in &
program
each cell independently. That would take forever.

I have seen some information on "Formula Is" but that appears to be an
Excel
2003 feature and I've been unable to find the right way to do this in
Excel
2007.

Help!!!!!?!?!?!!