Adding a second formatting condition.

  • Thread starter Thread starter bollard
  • Start date Start date
B

bollard

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
 
In your CF, change condition1 to Formula Is and use a formula of

=AND($D3="",$C3<$A$1-14)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top