| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight Expired dates
I am needing to be able to open my excel sheet and have it automatically
highlight the expired dates. For example, if I opened the sheet on November 10, 2008, it will highlight everything before 11/10/2008. Is this possible? I would greatly appreciate it! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight Expired dates
Suppose your dates are in Col A then
select Column A Choose Conditional Formatting Choose FORMULA IS in the first drop drown Paste =$A1<Today() Choose the formatting you want Click Ok and you are done "cbfry18" wrote: I am needing to be able to open my excel sheet and have it automatically highlight the expired dates. For example, if I opened the sheet on November 10, 2008, it will highlight everything before 11/10/2008. Is this possible? I would greatly appreciate it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find expired dates =IF((E11-TODAY()<0), "EXPIRED", "OK") | Excel Worksheet Functions | |||
| Conditional Format: Expired dates wanting cell to change color | Excel Discussion (Misc queries) | |||
| automatically highlight cells with expired dates?! | Excel Discussion (Misc queries) | |||
| How do I highlight expired dates automatically in excel. | Excel Discussion (Misc queries) | |||
| Output of expired dates | Excel Worksheet Functions | |||
Linear Mode
