See

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


In article ,
R of Steinke wrote:

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.