<div>
This solution works and it has examples on how to do it.
</div>


This solution works and it has examples on how to do it.

<div>
<div class="content wysiwyg-content">
Is there an IF statement that can recognize if a cell is a formula or a value?<br />
<br />
I have a worksheet where the user can override a formula with their value. &nbsp;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.<br />
<br />
I do not to use Visual Basic or Macros for this. &nbsp;<br />
<br />
Thank you. &nbsp;<br />
<br />
Tom
</div>
</div>


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

IF cell is a formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.