| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formating For Expired Dates
I have a column of dates, I would like to have the cell turn color when the
date in the cell is older than the current date. Is there a way that this can be done? This would easyly allow me to identify all past due accounts. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formating For Expired Dates
select your data and do Format=Conditional Formatting
see help on conditional formatting and also Debra Dalgleish http://www.contextures.com/tiptech.html look under C for conditional formatting. -- Regards, Tom Ogilvy "Prohock" wrote: I have a column of dates, I would like to have the cell turn color when the date in the cell is older than the current date. Is there a way that this can be done? This would easyly allow me to identify all past due accounts. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting with expired dates after current | Excel Worksheet Functions | |||
| conditional formating dates, please help me | Excel Discussion (Misc queries) | |||
| i need help with conditional formating with dates | New Users to Excel | |||
| Conditional Format: Expired dates wanting cell to change color | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Linear Mode
