Im using dates on my spreadsheet and I want to show a date to be highlighted if its greater than another cell by 18 months, If its less than another cell by 18 months, if it is between 9-12 months of another cell I would like to have it highlighted.
So for example
cell A1= 2/1/2019
cell B1= 7/1/2020
I want cell B1 to be green if it is 18 months or greater than cell A1
I want B1 to be blue if it is between 15-17 months less than cell A1
I want B1 to be yellow if it is 14 months or less than cell A1
Hoping you can help please.