How can I determine if a cell has a value (#) or a formula (X*Y)?

[Guest]

I would like to have the cell font color change (conditional format) to
denote whether there is a value (a simple number) or a formula in the cell
(X*Y) where X*Y could be a reference to another cell or just a typed in =2*3.

This will help users know when they should use some caution in changing an
input when there is a formula inside the cell or just simply over ride when
there is a simple dumb input.

Thanks for your help.

 

[Vito]

I found this in this link
http://www.j-walk.com/ss/excel/usertips/tip045.htm

1. Select Insert, Name, Define.
2. In the Define Name dialog box, enter the following in the 'Names i
workbook' box: ContainsFormula
3. Then enter the following formula in the "Refers to" box:
=GET.CELL(48,INDIRECT("rc",FALSE))
4. Click Add, and then OK.
5. Select all the cells to which you want to apply the conditiona
formatting.
6. Select Format, Conditional Formatting
7. In the Conditional Formatting dialog box, select Formula Is from th
drop-down list, and then enter this formula in the adjacent box
=ContainsFormula
8. Click the Format button and select the type of formatting you wan
for the cells that contain a formula.
9. Click OK

 

[Guest]

Vito,

Thanks a lot. I have been looking for that trick for quite some time.

Ken