Conditional format -> another cell

[CT]

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!!!!!?!?!?!!

 

[T. Valko]

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

Select cell A20

Goto Home tab>Styles>Conditional Formatting>Manage Rules

Click New Rule>Use a formula to determine...
Format values where this formula is true:
=B20<0
Click the Format button
Select the desired style(s)
OK>OK
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),B20>5)

Then, after you've set the third condition format: OK>OK>Apply>OK