Hi all,
Hoping someone can point me in the right direction with this one.
Having come back from a period of leave I have found that the conditional formatting in one of my spreadsheets has stopped refreshing/updating automatically. By that I mean it works but doesnt update the screen. This is the scenario although simplified for here.
Before if I put a "Y" in say cell A1 then it would format cells B1:D4 in the desired way.
For some reason now when I put a "Y" in cell A1 nothing happens HOWEVER if I switch to another sheet and then come back to the original sheet upon returning the conditional formatting to B1:D4 is applied. Almost as if the screen updating has been turned off somehow (first thing i checked)
anyone point me towards a solution
Hoping someone can point me in the right direction with this one.
Having come back from a period of leave I have found that the conditional formatting in one of my spreadsheets has stopped refreshing/updating automatically. By that I mean it works but doesnt update the screen. This is the scenario although simplified for here.
Before if I put a "Y" in say cell A1 then it would format cells B1:D4 in the desired way.
For some reason now when I put a "Y" in cell A1 nothing happens HOWEVER if I switch to another sheet and then come back to the original sheet upon returning the conditional formatting to B1:D4 is applied. Almost as if the screen updating has been turned off somehow (first thing i checked)
anyone point me towards a solution