Solved

Conditional formula - highlight cells not containing formulas

Posted on 2014-02-27
2
312 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

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 …

743 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now