| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color field if date equals certain criteria
I have a list of dates in column A.
I have todays date in cell C1. I want the date fields in column A to turn amber when they are equal to or less than 15 days from todays date, then red when they are overdue. Whats the formula for this please. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color field if date equals certain criteria
Hi,
Select your range then Format|Conditional format Select formula is and enter the formula =AND(A1<=TODAY(),A1TODAY()-15) Pick amber Click ADD Select formula is and enter the formula =A1<=TODAY()-15 Pick red You don't need to use the date in C1 Mike "RC" wrote: I have a list of dates in column A. I have todays date in cell C1. I want the date fields in column A to turn amber when they are equal to or less than 15 days from todays date, then red when they are overdue. Whats the formula for this please. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keep lines when one column equals certain criteria | Excel Worksheet Functions | |||
| Add values based on text color with the criteria of a date | Excel Worksheet Functions | |||
| How to: date field minus minutes equals new date | Excel Worksheet Functions | |||
| Textbox equals certain field of last record | Excel Programming | |||
| Function for summing values of a field by date criteria | Excel Programming | |||
Linear Mode
