| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? . |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
| Cell format will not update | Excel Worksheet Functions | |||
| Conditional formatting won't update until cell is selected: Excel | Excel Discussion (Misc queries) | |||
| auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
