Conditional Format Won't Update Cell

[dgregk]

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?

 

[Bernie Deitrick]

Cell D3's CF will update the way you want if cell D3 has a formula in it. If you just want to have
a constant value, then link it to a cell with that constant value.

HTH,
Bernie
MS Excel MVP

 

[Charles Williams]

If you are in Manual calculation mode the conditional format will not be
executed until the screen is repainted (which happens when you move to
another sheet and then back again or if the cell gets refreshed by you
entering a value or recalculating etc).


Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

 

[winnie123]

Hi,

Maybe it is because cell D3 is blank, try putting something into D3 and cell
if the conditional format works

 

[winnie123]

You can then delete the value in D3 if you need it to remain blank

 

[winnie123]

Sorry about the many answers, but format D3 to general, I have just tied it
and it works ok

 

[dgregk]

Thanks for the suggestions - D3 was a constant value (text) with a general
format assigned. Based on the suggestion from Bernie, I tried linking it to
another cell with that value, to put a formula in the cell instead of the
constant value. That didn't work either. Calculation is set to Auto.

 

[dgregk]

Auto was selected

If you are in Manual calculation mode the conditional format will not be
executed until the screen is repainted (which happens when you move to
another sheet and then back again or if the cell gets refreshed by you
entering a value or recalculating etc).


Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com




.

 

[dgregk]

Thanks Bernie - I thought you had it. I did have a constant value in that
cell. I tried linking to another cell within the worksheet and then a cell