Conditional formating - cell contains a formula

  • Thread starter Thread starter DaBeanie
  • Start date Start date
D

DaBeanie

I'm presently doing some work preparing a spreadsheet for budgeting an
want to use use a conditional format to differniate betwen cells with
formula and those containing a number or data. I can't see anything i
the Cell or IF???? function set

Thanks..................
 
Hi
you need a user defined function for this:
Function is_formula(rng As Range)
is_formula = rng.HasFormula
End Function

Now enter the following formula in the conditional format dialog
(assumption: for cell B1)
=IS_FORMULA(B1)
 
Back
Top