Hi There,

I have put in the macro for conditional formatting since i have more around
10 conditions. The problem now is the colors dont appear by itself, i always
need to double click on the cell to make the coloe appear. Likewise, the
color also doesnt come back to white when the value is changed. I need to
double click the cell to get back to white. Even if i refresh using F9 or
even if i close & open the file, it does not automatically change the color..

Any reasons?? I am not able to figure out what the problem could be.