I have a Conditional format for one cell set based on the value in another
cell. For example, I selected the €œUse a formula €¦€� function in conditional
formatting and input €œ=D$12<=0.7€� for cell D3.

The value of cell D12 will change to a value less than 0.7 but cell D3 will
not change color until I select another worksheet and then return to the
original worksheet, at which time the conditional format is correctly
applied.

There are other cells within the worksheet that have conditional format set
based on their own value which will update instantly as the value changes
below or above thresholds.

Any suggestions?