Excel conditional formatting with months EDATE

[Evans2]

Hi all,

I'm having a bit of trouble getting this conditional formatting with dates to work the way I want.

< 9 months = OK/Green
9-12 months = Warning/Yellow
>12 months = Problem/Red

I need to apply the formatting to the same column and the idea is that they will stack with red on top, yellow in the middle and green on the bottom.

The formatting for red is working - =L1<<edate(today(),-12) green="L1" and="">EDATE(TODAY(),-12) and green =L2>EDATE(TODAY(),-9)

But I'm not sure how to format 9-12 months in Yellow.

Any help is appreciated.

Thanks</edate(today(),-12)>

 

[Joe4]

Try:

[COLOR=#333333] =AND(L1>=[/COLOR]<edate(today(),-12) green="L1" and="" style="color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">EDATE(TODAY(),-12)L1<=EDATE(TODAY(),-9))</edate(today(),-12)>

 

[Evans2]

Thank you, sir!

 

[Joe4]

You are welcome!