| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Experation Date
I have a column in which I have different expiration Dates. I would like the
box to change color to amber when today's date is 90 days from the expiration date and then red when 30 days from the expiration date. The actual formula would be most useful. Thank you in advance. Arlan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highlight records on experation date( Excel 2003) | Excel Discussion (Misc queries) | |||
| Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
| how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
![Arlan[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
