Conditional formula - highlight cells not containing formulas

IO_Dork
IO_Dork used Ask the Experts™
on
Define Name:
 "CellHasFormula"

formula in the "Refers to" box
 =GET.CELL(48,INDIRECT("rc",FALSE))

apply the conditional formatting - formula:
=CellHasFormula  


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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2008
Commented:
Use:

=NOT(GET.CELL(48,INDIRECT("rc",FALSE)))

Kevin

Author

Commented:
excellent!! thank you.  I did not realize it could be that easy.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial