Conditional Formatting using 3 Traffic Lights Formula
 

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

Conditional Formatting using 3 Traffic Lights Formula
 

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

Conditional Formatting using 3 Traffic Lights Formula
 

When I place in the (see below) following formulas, I receive an error back
saying "You cannot use relative references in Conditional Formatting criteria
for color scales, data bars, and icon sets."

= =$D2=0
= =$D2=-3

I have the "Type" drop-down box set to "Formula". With the greater than
or equal to operators being selected beforehand, I don't know if that makes
any difference. The only two choices I have are that or just greater than.
That is why I assume I should be able to set the Value formulas to just be
equal to one value (see below).

= =$D2=0
= =$D2=-3

This still isn't giving me the break out I am looking for. All traffic
lights come up Green if I use that method.

nathan


"Luke M" wrote:

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

Conditional Formatting using 3 Traffic Lights Formula
 

Is there no way to post a screenshot on here? I believe that would be best
for showing how I need this to get completed. I'm stuck on this issue, and I
have a a tight deadline to get this project completed. Any and all help would
be much appreciated!

"Luke M" wrote:

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