Excel 2007 3 Traiffic Light Conditional Formatting

B

BureFreak

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
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting using 3 Traffic Lights Formula 3
Setting an Icon Set conditional format for a single cell??? 1
Conditional Formatting 1
Conditional Formatting using Traffic Lights 6
Conditional Formatting with Icon Sets 0
Counting cells based on cell formatting 10
Copy Conditional Formatting to Another Sheet 3
Conditional Formatting 4

Top