Use a UDF

Function IsFormula(rng As Range)
If rng.Count 1 Then
IsFormula = CVErr(xlErrRef)
Else
IsFormula = rng.HasFormula
End If
End Function


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"R of Steinke" wrote in message
...
How can I tell if a cell contains a formula versus a number or text?
(apart
from looking at it). i want to create a conditional format for cells so
that
if users enter a formula (or reference to another cell - basically
anything
starting with "=" , it appears in a different format.