Forum Discussion
Conditional Formatting
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.
Thank you so much for taking some time to help me on this. However I think this is still not what I am going for.
I need the dates to be in the past and for the document to inform me of future upcoming dates. So for example:
The one annual was completed on the 7/10/2018 - when it gets to around April the document cell should change to Green for 90 days out from due date - then Blue for 60 days out in May - and then Yellow for 30 days out in June - by the time it is July 2019 the chart for that cell should turn Red indicating it is about to expire.
Does that make sense?
- Jo
