| 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? |
| 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 | |||
Threaded Mode
