Conditional Formatting Not Automatically Changing

[mubashir aziz]

Hello,
I am using MS Excel 2010 and applied below conditoinal Formatting from H8:H15 cells.
'=AND($E4="Yes",$K4<>"Closed",$H4<TODAY(),$H4<>"")

Now the problem is this that if I do some cahnges in E column with Yes or in K column with Closed. H Cell never changes automatically!!! If i double clock inside of that cell that its color changes or If i save & close work book and then open it work. But its not automatically changing.

I've checked Auto Calculatoin and its ON.

any solution please .

Thanks

Conditional foramt.xlsx

[Fotis1991]

Hi

Maybe you have some macros in your Sheet... I had, same problem in your sheet.

But not, in a new one(copy-paste)....

[mubashir aziz]

I ve checked and there is no macro but anyway problem has been solved with your kind advise.

Thanks a lot .....

[Fotis1991]

You are welcome

Thanks for feed back and also for reb*