Conditional formating - cell contains a formula

[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..................

 

[Frank Kabel]

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)

 

[DaBeanie]

Thanks for your response Frank that's brilliant - it works perfectly

: