Formula Dates - 3 Conditions

[Joachim21]

For 2 days I'm thinking how to do this conditional formatting. It would be great if someone can help.
1. If the date in the cell is more than or equal to Todays date it will be highlighted with red.

2. If the date in the cell (compared to today's date) is less than or equal to 30 days it will be highlighted with yellow.

3. If the date in the cell (compared to today's date) is more than 30 days it will be highlighted with green.

Thanks in advance.

 

[AlanY]

Re: Help with Formula Dates - 3 Conditions

your conditions 1) and 3) are incompatible, please clarify.

e.g if cell date is today+2 months, red or green?

 

[Joachim21]

Re: Help with Formula Dates - 3 Conditions

First of all, thank you for the reply/help. Sorry for the confusion. Just to sum up or simplify the 3 conditions:
E.g.: 29/03/2019
1. Highlight the date in Red - If today's date is present/future with regards to cell date - Expired
2. Highlight the date in Yellow - If 1 month before cell date - Warning
3. Highlight the date in Green - If more than 1 month before cell date - Valid

Is this possible?

Thanks,

 

[Joachim21]

Re: Help with Formula Dates - 3 Conditions

First of all, thank you for the reply/help. Sorry for the confusion. Just to sum up or simplify the 3 conditions:
E.g.: 29/03/2019
1. Highlight the date in Red - If Cell date is present/future - Expired
2. Highlight the date in Yellow - If 1 month before cell date - Warning
3. Highlight the date in Green - If more than 1 month before cell date - Valid

Is this possible?

Thanks,

 

[AlanY]

Re: Help with Formula Dates - 3 Conditions

like this?

https://imgur.com/a/HocmT3h

have a look the file in
https://drive.google.com/file/d/1pYISvjG4vVEh-wXkD89HjIghXUgzaO0v/view?usp=sharing

 

[esgca2010]

Re: Help with Formula Dates - 3 Conditions

This is exactly what I want but I have a customer that wants 3 colors based on 3 conditions using 1 formula in 1 conditional formatting rule. Is this possible?