Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Traffic Light with dates
I’m trying to use the conditional formatting, traffic light feature
with dates and am finding the new Edit Formula Rule app to be rather limiting. Hopefully it’s just my ignorance. Cell E1 contains current date (updated when the workbook is opened) several other cells have fixed expiration dates. In the expiration date cells I want traffic lights indicating: red once the date matches current, yellow seven days in advance, and green anytime the date in the cell is greater than 7 days beyond the current date. I can get red and green to work but getting yellow is a mystery. Green value is set to “E1” and Type set to Number Yellow says “when < formula and” then there is an option to select or “=” and enter a value. In the value I have tried “=E1+7 just “=7” etc but all I can accomplish is that yellow never works or will always work when the date is exceeded with red never working. I assume that yellows formula in “when < formula and” is referring to the “value” for green even if number is selected for green instead of “formula”. Makes me think that I could never create the condition I want. If I sound confused it’s because I am! The help feature does not explain the feature that I can find Any help will be appreciated. Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
traffic light in excel | Excel Discussion (Misc queries) | |||
traffic light formula | Excel Discussion (Misc queries) | |||
traffic light based on 3 different conditions | Excel Worksheet Functions | |||
Traffic light problem | Charts and Charting in Excel | |||
Traffic Light Filter On Dates | Excel Discussion (Misc queries) |