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

[Guest]

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.

 

[Guest]

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

 

[Guest]

Thank you PD that has fixed it