Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In my spreadhseet, I have today's date in cell A1 using today()
In Column C, I want cells to show up red if the date in the cell is over 14 days ago. I've achieved that with this conditional formatting: Cell Value Is...less than...$A$1-14 BUT I want C3, for example, to revert to black font on white if a date in input into D3 and C4 likewise if there's a date in D4 etc. Can anyone suggest how to achieve this, please? Thanks Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting - adding condition on formula | Excel Discussion (Misc queries) | |||
If formula---adding another condition | Excel Discussion (Misc queries) | |||
Adding numbers that meet a condition? | Excel Discussion (Misc queries) | |||
adding part of a function on condition. | Excel Worksheet Functions | |||
Adding different validations based on condition | Excel Worksheet Functions |