ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My conditional formatting evaluates only when I double click cells (https://www.excelbanter.com/excel-discussion-misc-queries/248612-my-conditional-formatting-evaluates-only-when-i-double-click-cells.html)

jco

My conditional formatting evaluates only when I double click cells
 
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?


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com