Conditional Format Won't Update Cell

  • Thread starter Thread starter dgregk
  • Start date Start date
D

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?
 
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
 
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
 
Hi,

Maybe it is because cell D3 is blank, try putting something into D3 and cell
if the conditional format works
 
Sorry about the many answers, but format D3 to general, I have just tied it
and it works ok
 
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.
 
Auto was selected

Charles Williams said:
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




.
Click to expand...
 
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
 
Back
Top