| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula in conditional formatting with dates
Cell A1 = doc status with the following possible values:
"Due", "Revise", "Sign", "Complete". Cell A2 contains a date. I need a formula for conditional formatting that will turn Cell A2 yellow with blue bold font if A1="Due" or "Sign" AND Cell A2 is within 31 days of today's date. Todays date is located in cell A3 as =TODAY(). I have used the conditional formatting function alot in very basic ways, but am somehow just not able to work out this formula. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting formula for past due dates | Excel Discussion (Misc queries) | |||
| Using Conditional Formatting for Dates | Excel Discussion (Misc queries) | |||
| conditional formatting with dates | Excel Worksheet Functions | |||
| Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) | |||
| Conditional Formatting Dates | Excel Worksheet Functions | |||
Threaded Mode
