Conditional formatting

[Jafbr]

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. I've attached a sample file.

How would I go about doing this?

Thanks for any help!

 

[jakeman]

There's no attachment. What is the range of values that you are applying the conditional format to?

 

[Fluff]

Select the range you want this to work on > Home tab > Conditional Formatting > New Rule > use a Formula > =G2>EDATE(NOW(),1) > select the format > OK
This will do the greater than 1 month. Change G2 to the first cell in the range

 

[Jafbr]

There's no attachment. What is the range of values that you are applying the conditional format to?

It won't allow me to post attachements