Due dates & conditional formatting - not working

[Camel123]

Hi,

Please see snapshot from Excel:
https://imgur.com/pQdHs71

Why does it not color the "current selection" J4:J300?

Also tried this;
=IF(AND(DATEDIF($J4;$L$2;"M")>=3;TODAY()>$L$2)

Not working. I want it to color cells with dates that 3 months due.

 

[Fluff]

Your image shows that you have quotes around the formula, you need to remove them.

 

[Camel123]

My Excel does that when applying the conditional formatting. I insert this =datedif($J4;$J$2;"m")>=3

 

[Fluff]

Are you manually adding the CF, or via a macro?

 

[Camel123]

Are you manually adding the CF, or via a macro?

I am doing it manually through CF. Any tips on how to solve? Still not managed to solve the issue.

 

[Fluff]

And you're saying that if you type in this formula
=datedif($J4;$J$2;"m")>=3
Xl changes it to
="datedif($J4;$J$2;""m"")>=3"