| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Difference Between Dates WITH Conditional Formatting
I want cell C2 to turn RED if it is more than two days different than the
date in cell B2. Oddly, the formula "=B2-TODAY()2" works, but that is not what I want to do. I want to say "=B2-C2()2", but the cell does not change color. MS Excel just stared back at me. An exhaustive search of the www was of no avail. Suggestions are welcome. DOUG ECKERT Wichita KS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting with Dates | Excel Discussion (Misc queries) | |||
| conditional formatting - dates | New Users to Excel | |||
| Conditional Difference between two dates | Excel Discussion (Misc queries) | |||
| Conditional Formatting - Difference between dates | Excel Discussion (Misc queries) | |||
| Conditional Formatting (Dates) | Excel Discussion (Misc queries) | |||
Threaded Mode
