Conditional Formatting

[Jaf]

Hello there,
I'm creating a file in which due dates are monitored. I would like the cell to be green if the due date is >1 month from today, orange if <1month from today, red if past due date, and no color if empty. I've attached a sample file.

How would I go about doing this?

Thanks for any help!

 

[Thangavel]

HEllo,
Pls checkout here & you can modifi as you required
https://www.ablebits.com/office-addins-blog/2014/06/17/excel-conditional-formatting-dates/