You could insert this short UDF into a module in the Visual Basic Editor, and
then call the formula IsFunction to check for a formula.

'========
Function IsFunction(TestCell As Range) As Boolean
If Left(TestCell.Formula, 1) = "=" Then
IsFunction = True
Else
IsFunction = False
End If
End Function
'========
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Neil Pearce" wrote:

Hi there,

Thank you.

That is great for locating those cells which contain a formula. However I
am hoping to create a formula such that conditional formatting will highlight
a cell if that cell no longer caontinas a formula but is instead overwriten
with a hard number by a user.

e.g. NOT(ISFORMULA(A1)) then fill cell yellow.

"JLatham" wrote:

Edit -- Go To -- [Special] and choose Formulas and the sub option(s) in
that list for the type of results, Number, text, etc, that you are looking
for.

"Neil Pearce" wrote:

All,

I am aware of the IS forumlae. But how would I test if a cell is a function
that calucates a number as opposed to a hard inputted number? The end goal
being to highlight any cells where a formula is overwritten using conditonal
formatting.

The forumla in question being:

=IF(NOT(B9=""),VLOOKUP(B9,'Project Overview'!$A$34:$E$52,COLUMNS('Project
Overview'!$A$33:$E$33),FALSE),0)


Appreciated as always,

Neil