Conditional formatting on Date
 

I have a cell with a training date. I would like to format the cell to
change color when actual date exceeds training date by one year.

Conditional formatting on Date
 

in Conditional formatting, formula is

=cell<=now()-365

"Rick1" wrote:

I have a cell with a training date. I would like to format the cell to
change color when actual date exceeds training date by one year.

Conditional formatting on Date
 

Select "Formula Is" and use this conditional formula...

=DATEDIF(A1,NOW(),"y")0

--
Rick (MVP - Excel)


"Rick1" wrote in message
...
I have a cell with a training date. I would like to format the cell to
change color when actual date exceeds training date by one year.

Conditional formatting on Date
 

That could give an incorrect result in a leap year.

--
Rick (MVP - Excel)


"Sean Timmons" wrote in message
...
in Conditional formatting, formula is

=cell<=now()-365

"Rick1" wrote:

I have a cell with a training date. I would like to format the cell to
change color when actual date exceeds training date by one year.

Conditional formatting on Date
 

I used A1 in my formula, but you should use your actual cell address
instead.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
Select "Formula Is" and use this conditional formula...

=DATEDIF(A1,NOW(),"y")0

--
Rick (MVP - Excel)


"Rick1" wrote in message
...
I have a cell with a training date. I would like to format the cell to
change color when actual date exceeds training date by one year.

Conditional formatting on Date
 

Perfect! Thanks for your help guys!!

"Rick Rothstein" wrote:

I used A1 in my formula, but you should use your actual cell address
instead.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
Select "Formula Is" and use this conditional formula...

=DATEDIF(A1,NOW(),"y")0

--
Rick (MVP - Excel)


"Rick1" wrote in message
...
I have a cell with a training date. I would like to format the cell to
change color when actual date exceeds training date by one year.