| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set conditional traffic lights depending on adjacent cell value | Excel Discussion (Misc queries) | |||
| Conditional formatting as a formula | Excel Worksheet Functions | |||
| Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
| How do I use traffic lights in excel | Excel Discussion (Misc queries) | |||
| How do I get traffic lights in excel that change colour | Excel Worksheet Functions | |||
Threaded Mode
