| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
traffic light formula
I am trying to create a traffic light formula in excel 2003. I want a cell B2
at the beginning of my spreadsheet to be green, if the date in cell K2 is a minimum of 3 months away, amber if it is less than 3 months away and red if it equal to or the expiry date. Hoping you can help! Vikki |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| traffic light in excel | Excel Discussion (Misc queries) | |||
| traffic light based on 3 different conditions | Excel Worksheet Functions | |||
| I neen a chart background to represent traffic light colors... | Charts and Charting in Excel | |||
| Traffic light problem | Charts and Charting in Excel | |||
| Traffic Light Filter On Dates | Excel Discussion (Misc queries) | |||
Threaded Mode
