Solved

# Conditional formula - highlight cells not containing formulas

Posted on 2014-02-27
312 Views
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
Question by:IO_Dork

LVL 81

Accepted Solution

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

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

Kevin
0

Author Closing Comment

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

## Featured Post

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …