How can I conditionally format cells that contain formulas?
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 Student
"jhofmann" wrote:
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 "Go To...","Special","Formulas" but would prefer to have
the process happen automatically.
TIF ...
|