software

Is it possible to create a conditional format for a group of cells that would
set a specific backgroup color for cells that contain formulas as opposed to
data?

I have been using quot;Go To...quot;,quot;Specialquot;,quot;Formulasquot; but would prefer to have
the process happen automatically.

TIF ...

Create a UDF and use that in the CF formulaFunction IsFormula(rng As Range)
IsFormula = rng.HasFormula
End Function

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jhofmannquot; gt; wrote in message
...
gt; Is it possible to create a conditional format for a group of cells that
would
gt; set a specific backgroup color for cells that contain formulas as opposed
to
gt; data?
gt;
gt; I have been using quot;Go To...quot;,quot;Specialquot;,quot;Formulasquot; but would prefer to have
gt; the process happen automatically.
gt;
gt; TIF ...
First enter this tiny UDF:

Function IsFormula(r As Range) As Boolean
IsFormula = r.HasFormula
End Function

Then set Conditional formatting: Formula is:

=(IsFormula(A1))

--
Gary''s Studentquot;jhofmannquot; wrote:

gt; Is it possible to create a conditional format for a group of cells that would
gt; set a specific backgroup color for cells that contain formulas as opposed to
gt; data?
gt;
gt; I have been using quot;Go To...quot;,quot;Specialquot;,quot;Formulasquot; but would prefer to have
gt; the process happen automatically.
gt;
gt; TIF ...