| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with dates
Hi Tom,
Its ok i've got it now. Thanks for your help "Craig" wrote: Hi Tom, Thanks for the reply. I entered the conditional formatting as you said below and set it so that the cell would change to red once the condition had been met. In cell A1 i entered a date of 03-Nov-2006 and in cell A2 i entered 3 (number of years). The cell in A1 changed to red but it shouldn't do until 03-Nov-2009 because the certificate is valid for three years. I'm not sure why its doing that. Would the date format make any difference? Kind Regards Craig "TomPl" wrote: If the training date is in cell A1 and the years it is valid is in cell A2 then apply this conditional formatting to cell A1: Condition - Cell Value - is less than - =DATE(YEAR(TODAY())-B1,MONTH(TODAY()),DAY(TODAY())) This formula is based on the current date but could be modified to work with any date you specify. Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dates and conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting with Dates | New Users to Excel | |||
| Conditional formatting dates | Excel Discussion (Misc queries) | |||
| Dates in Conditional Formatting help!!! | Excel Worksheet Functions | |||
| Conditional Formatting for dates | Excel Worksheet Functions | |||
Threaded Mode
