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

J

JonMAd

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.
 
P

pdberger

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top