A function to indicate whether a cell contains formula or value?

[Dave T]

Is there a function to return logical indication of whether a cell contains
formula or value? Need it for conditional cell formating.

 

[Peo Sjoblom]

Not built in

http://www.mvps.org/dmcritchie/excel/formula.htm#HasFormula

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Gord Dibben]

With a User Defined Function such as

Function IsFormula(cell)
Application.Volatile
IsFormula = cell.HasFormula
End Function


Gord Dibben MS Excel MVP