| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Before today
I have a spredhseet in Excel 2007 that shows lots of policy dates with
expiration dates in one column. I need a formula that would allow all expired dates to turn red so that I can easily see them. Thanks so much! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Before today
Sounds like you want to use a conditional format (Format - conditional
format) but for that to work there must be something that distinguishes the expiriation dates from the rest of the dates. -- HTH... Jim Thomlinson "MAustin" wrote: I have a spredhseet in Excel 2007 that shows lots of policy dates with expiration dates in one column. I need a formula that would allow all expired dates to turn red so that I can easily see them. Thanks so much! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Before today
Re-reading your question are you looking to highlight the policy dates that
are prior to today? If that is the case then use this formula in your conditional format Cell Value is | Less Than | =Today() Change the format option to Red text... -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: Sounds like you want to use a conditional format (Format - conditional format) but for that to work there must be something that distinguishes the expiriation dates from the rest of the dates. -- HTH... Jim Thomlinson "MAustin" wrote: I have a spredhseet in Excel 2007 that shows lots of policy dates with expiration dates in one column. I need a formula that would allow all expired dates to turn red so that I can easily see them. Thanks so much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| TODAY() | Excel Worksheet Functions | |||
| Today()-1 | Excel Discussion (Misc queries) | |||
| How is everyone today? | Excel Discussion (Misc queries) | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
Linear Mode
