Conditional Formatting

Hello

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.
By: Vee

Leave a Reply

Your email address will not be published. Required fields are marked *