| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Confitional Formatting using (Red/Yellow/Green) for due dates
If your exp. dates are in column A, then
formula for red: A2<Today() for yellow: A2<Today()+30 for green: A2<Today()+30 Regards, Stefi Inward-Smile(Meka) ezt *rta: Hey, Need help with the following problem, hope someone can help. see below: I'm created a spreadsheet with a column for "Employee Driver's License Exp. Dates". I want to setup a rules that format certain cells to be highlighted in red, when they expire anytime before today's date. Second, I want to highlight cells "Yellow", if the date within a cell is within 30 days of the expiration date. Lastly, and third, I would like to highlight cells "Green", if the cell's date is within 60 days of expiration. Any suggestions or explicit, detailed instructions would be greatly appreciated. I tried the Demo in Microsoft Excell 2003, but I ended up making all my cells "Red"! Yeesh Please help :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - Looking for Red/Yellow/Green Icons, w/ wo | Excel Worksheet Functions | |||
| I need to add a blinking red, yellow and green light to an excel | Excel Discussion (Misc queries) | |||
| Can I sort columns by colors, example - red, green, yellow | Excel Discussion (Misc queries) | |||
| Add fill colors: green & red & yellow on toolbar, instead clickin. | Excel Worksheet Functions | |||
| formatting red amber green for copying | Excel Worksheet Functions | |||
Threaded Mode
