Conditional formats that are locked and do not change when copy/ cut and paste actions are performed.
Today I have conditional formats with formula. A copy and past action which is done often, will mess up the formatting. It tries to compensate for the change. However, it is rare that it gets the change correct. Instead the conditional formats double, triple or have errors in them. I want to have the ability to set a conditional format and have it static and not change until I decide to change it. e.g. =AND($E9<>0,$E10=0) with applies to: =$B:$I,$K:$M
When I copy and paste (and any type of paste) the formula and cells affected are changed so that the format is no longer correct. With a radial button to set the format as static the problem would be solved.