Solved

Conditional formula - highlight cells not containing formulas

Posted on 2014-02-27
2
324 Views
Last Modified: 2014-02-27
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?
0
Comment
Question by:IO_Dork
2 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 500 total points
ID: 39893159
Use:

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

Kevin
0
 

Author Closing Comment

by:IO_Dork
ID: 39893247
excellent!! thank you.  I did not realize it could be that easy.
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question