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.
How did you get that to work!!!! I tried duplicating your formulas to see if it is just me and I cannot get them to go! You have been an amazing help.
Can you do that for every 2 years in the future and every ten?
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.
Sergei you have been an absolute savior for me today! Thank you so much for being so patient with me and helping me out!