I have a worksheet, with the calculation is set to manual
, where the on one sheet the formatting of one range of cells is dependant on the boolean value of another cell on the same sheet. I am using Excel 2010.
I then created a second range on a second sheet that also depends on the same control cell.
If I change the value of the control cell then the cells on sheet 1 do not
change their formatting. If I switch to sheet 2 then the sheet 2 range has changed there formatting (based on the control cell in sheet1). If I switch back to sheet 1 then the range on that sheet has now had it's formatting updated also.
I can repeat these actions over and over again with the same result.
To put is simply :
the refresh of the conditional formatting is only performed the the worksheet changes when the calculation mode is set to manual. If the calculation mode is set to auto then of course all formatting is updated immediately.
My question :
Is this normal expected behaviour ?
I have attached a sample file to demonstrate this point. The control is the yellow cell on sheet 1.