How to check whether a cell contains a formula or a value

[Eric Jan van de Veen]

I would like to mark (f.i. by conditional formatting) cells that contain a
formula. In this way a user can deliberately choose to overwrite the value
genereted by the formula.

 

[Bob Phillips]

Add this simple UDF

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

and a conditional formatting formula of
=IsFormula(A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Nick]

Highlight a formula cell without code. Regards to Ian Brown FCA
([email protected])

Select cell A1 on any sheet in the workbook
Define the name CellHasFormula (using Insert | Name | Define) as
=GET.CELL(48,!A1)

In Format | Conditional Formatting use a "Formula Is" setting of
=CellHasFormula
to trigger the defined formats.

Apply the conditional formatting as required

 

[Bob Phillips]

But beware that if you copy this cell in XL2000 or earlier, you will crash
and burn.

--

HTH

RP
(remove nothere from the email address if mailing direct)