Conditional Format Won't Update Cell
 

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?

Conditional Format Won't Update Cell
 

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


"dgregk" wrote in message
...
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?

Conditional Format Won't Update Cell
 

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" wrote in message
...
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?

Conditional Format Won't Update Cell
 

Hi,

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

"dgregk" wrote:

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?

Conditional Format Won't Update Cell
 

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

"winnie123" wrote:

Hi,

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

"dgregk" wrote:

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?

Conditional Format Won't Update Cell
 

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

"winnie123" wrote:

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

"winnie123" wrote:

Hi,

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

"dgregk" wrote:

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?

Conditional Format Won't Update Cell
 

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.

"winnie123" wrote:

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

"winnie123" wrote:

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

"winnie123" wrote:

Hi,

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

"dgregk" wrote:

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?

Conditional Format Won't Update Cell
 

Auto was selected

"Charles Williams" wrote:

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" wrote in message
...
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?




.

Conditional Format Won't Update Cell
 

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
on another worksheet - neither worked.

"Bernie Deitrick" wrote:

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


"dgregk" wrote in message
...
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?



.