Forum Discussion
Conditional Formatting
Hello and Please Help!
I have been attempting to set up an excel sheet with conditional formatting to tell me when I have upcoming appointment dates. I would like the formats to include a 90 day / 60 day / 30 day warning and then the expiration date. I have tried multiple formulas and when I attempt to check the formula the rule doesn't work. I am unsure what I am doing wrong. PLEASE HELP!
The column that starts has the original date for the current annual physical - I need the formatting to tie into what I explained above.
- Jo
Joleane, 2 and 10 years, whatever, is exactly the same, you only need instead of EDATE(B3,12) which gives the same date in 12 months ahead, to use EDATE(B3,24), EDATE(B3,240), etc. And add more colors / rules for each such period.
Hi Joleane,
If A1 is the first cell of your range, formula for the first conditional formatting rule could be
=TODAY()>=A1
for the next rule
=TODAY()>=A1-30
etc
Hello and Thank you for responding - I am attempting to do this for a full column and when I do it changes the entire column color. I included the document. I am extremely frustrated with this.
All your dates in the sample are in the past - I added few future ones. Rules looks like this
and Green formula is
=(TODAY()>=B3-90)*NOT(ISBLANK(B3))
Compare to previous one I excluded blank cells from formatting. Rest is similar.
File attached.
