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

Adding a second formatting condition.
 

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)

"bollard" wrote in message
...
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

Adding a second formatting condition.
 

Hi Bob

Many thanks for your swift reply. It works.

"Bob Phillips" wrote:

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)

"bollard" wrote in message
...
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