My conditional formatting evaluates only when I double click cells

J

JCo

I have conditional formatting to change cell colour when formula evaluates to
true. When I change the cells referenced by the formula to make it true, the
conditional formatting does not apply. However, if I double click the area
of the cf cells, then it works. Or if I move away from the sheet then back
again. Calculation is set to automatic. Any idea what is wrong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top