Function: cell contents formula or value?

[J.Smith]

Hi,
It seems like a trivial thing, but I seem to be unable to locate a worksheet
function that allows me to determine, if a given cell contents is a formula
or a value.

Thank you!

 

[Max]

It seems like a trivial thing, but I seem to be unable to locate a worksheet
function that allows me to determine, if a given cell contents is a formula
or a value.

Try the F5* > Special route (options are available there)
*or click Edit > Go to.. , or Press Ctrl+G

Press F5 > Special > Check "Formulas" > OK
will select all formula cells on the sheet at one go
Then we could apply Format > Cells > Font tab (to taste)

Similarly, we could also select the constants:
Press F5 > Special > Check "Constants" > OK
then apply format to taste, etc ...

 

[J.Smith]

Thanks, Max, but I was looking for a worksheet function which does that.
Thanks for replying, anyway!

 

[Max]

Thanks, Max, but I was looking for a worksheet function which does that.
Thanks for replying, anyway!

No prob, was just venturing a guess as to your underlying intent.
Thanks for the feedback ..

 

[Harlan Grove]

J.Smith wrote...

It seems like a trivial thing, but I seem to be unable to locate a worksheet
function that allows me to determine, if a given cell contents is a formula
or a value.

No built-in function to do this. You could use VBA to write a
user-defined function. UDFs need to go into general VBA modules, not
class modules.

Function isformula(r As Range) As Boolean
isformula = r.Cells(1).HasFormula
End Function