| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
My conditional formatting evaluates only when I double click cells
I have conditional formatting to change cell colour when formula evaluates to
true. When I change the cells referenced by the formula to make it true, the conditional formatting does not apply. However, if I double click the area of the cf cells, then it works. Or if I move away from the sheet then back again. Calculation is set to automatic. Any idea what is wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protected Worksheet, Cell Formatting Lost on Double Click? | Excel Discussion (Misc queries) | |||
| How to change display format - double click for precedent cells? | Excel Discussion (Misc queries) | |||
| Double Conditional Formatting | Excel Discussion (Misc queries) | |||
| How to change syperlink from single click to double click | Excel Worksheet Functions | |||
| Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Threaded Mode
