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

Nathan,

AFAIK, you can only use the icon sets for the values within the cells that you are formatting.
Otherwise, you need to use traditional CF, with two conditions, by selecting cell A2 and then using
formulas like

=D2>=0 Format for Green
=D2<=-3 Format for Red
Format the cells as Yellow for the third condition. Then copy the formatting down.

HTH,
Bernie
MS Excel MVP


"BureFreak" <BureFreak@discussions.microsoft.com> wrote in message
news:FE8051D0-7E25-427B-8D05-FBA1F8774765@microsoft.com...
> 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 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