View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bollard bollard is offline
external usenet poster
 
Posts: 65
Default Adding a second formatting condition.

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