Solved

IF cell is a formula

Posted on 2013-01-24
2
252 Views
Last Modified: 2013-01-24
Is there an IF statement that can recognize if a cell is a formula or a value?

I have a worksheet where the user can override a formula with their value.  I would like to use a conditional format with a formula that if the cell is a value, the fill is a light gray color.

I do not to use Visual Basic or Macros for this.  

Thank you.  

Tom
0
Comment
Question by:ThomasJue
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 38816405
0
 

Author Closing Comment

by:ThomasJue
ID: 38816518
This solution works and it has examples on how to do it.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

777 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