How do I use condiftional formatting to indicate a formula?

[Gord Dibben]

Add this UDF to a general module in your workbook.

Function IsFormula(Cell)
IsFormula = Cell.HasFormula
End Function

Then CF>Formula is: =isformula(cellref)

Format to a color and OK.


Gord Dibben MS Excel MVP