Make sure you're using the "formula is" not "cell value is" callout.
In your first cell in b2, the three formulas would be
=$D2=0
=$D2=-3
=$D2<-3

With formats of green, yellow, and red respectively.

Since there is no placeholder in front of the row now, you can copy this
down to the other cells you want it in.

--
Best Regards,

Luke M


"BureFreak" wrote:

Does anyone know how to get this to work using the 3-light conditional
formatting in Excel 2007 using the reference to another cell? I need it
pretty much the same way as listed above, but it is not working for me.

Here is the set up I currently have.

ROW 1 MTD ACTUAL BUDGET DIFFERENCE
ROW 2 120 120 130 -10

I want the 3-Light Conditional Formatting Formula to be used on the MTD
column with this formula set up below.

GREEN LIGHT = =D2=0
YELLOW LIGHT = =D2=(-3)
RED LIGHT

Why is this not working? Any and every bit of help would be most appreciated!

Thanks,

nathan