Conditional formula - highlight cells not containing formulas
Posted on 2014-02-27
formula in the "Refers to" box
apply the conditional formatting - formula:
The above method provides the means to set a conditional formatting to cells that contain formulas only. I am looking to do the opposite...for a specific set of cells I want to highlight them if they contain anything but a formula. This way the user will see right away if he overwrote the formula cell by accident. Is there away to modify the above method to do this, or is there a completely different approach to this?