Conditional Format for a date 1 month before Expiration in Excel 2
 

Hi All,
I am trying to make a cell change colour 1 month before a date becomes
overdue to flag it for attention. I can do this without worries for a 6
month review, but a 12 month review will not change, it will change format
when it becomes overdue.
I am using
=IF(TODAY()=$C11+153,1,0) to change it 1 month before the 6 month
expiration date &
=IF(TODAY()=$C11+334,1,0) for 12 month. I seem to recall that Excel only
allows for 300 days in year calculations? Is that the problem and is there a
way to get around this. Thanks in advance.

Conditional Format for a date 1 month before Expiration in Excel 2
 

JMA --

I got it to work like this. My date (over a year ago) was in A1. I
activated conditional formatting on cell B1 as follows:

Formula is ... =TODAY()=(A1+334)

I set it up to make the cell turn red if the condition is satisfied, and it
worked fine.

HTH

"JonMAd" wrote:

Hi All,
I am trying to make a cell change colour 1 month before a date becomes
overdue to flag it for attention. I can do this without worries for a 6
month review, but a 12 month review will not change, it will change format
when it becomes overdue.
I am using
=IF(TODAY()=$C11+153,1,0) to change it 1 month before the 6 month
expiration date &
=IF(TODAY()=$C11+334,1,0) for 12 month. I seem to recall that Excel only
allows for 300 days in year calculations? Is that the problem and is there a
way to get around this. Thanks in advance.

Conditional Format for a date 1 month before Expiration in Exc
 

Thank you PD that has fixed it 8-)
--
Living Free and Easy in the State of Confusion


"pdberger" wrote:

JMA --

I got it to work like this. My date (over a year ago) was in A1. I
activated conditional formatting on cell B1 as follows:

Formula is ... =TODAY()=(A1+334)

I set it up to make the cell turn red if the condition is satisfied, and it
worked fine.

HTH

"JonMAd" wrote:

Hi All,
I am trying to make a cell change colour 1 month before a date becomes
overdue to flag it for attention. I can do this without worries for a 6
month review, but a 12 month review will not change, it will change format
when it becomes overdue.
I am using
=IF(TODAY()=$C11+153,1,0) to change it 1 month before the 6 month
expiration date &
=IF(TODAY()=$C11+334,1,0) for 12 month. I seem to recall that Excel only
allows for 300 days in year calculations? Is that the problem and is there a
way to get around this. Thanks in advance.