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.
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
Joleane, let me clarify if I understood correctly
2018-07-10 Annual Physical 2019-07-10 Red starting from this date 2019-06-10 Yellow to above date 2019-05-11 Blue to above date 2019-04-11 Green to above date No format before above date
For that sample all dates are in future, thus it'll be no format for that cell for today.
Yes that is what I needed!!!!
