hi, thanks; seems I have hardest time with code.
with this example pasted on sheet 2 tab, (right-click, view code, paste..)
did hit save, not sure if necessary; entering a cond. format for background
to go red (for: =isformula(K12)), nothing happens for any present of:
formula, number, empty, text

imagine something simple i am missing

"Gord Dibben" wrote:

Add this UDF to a module in your workbook.

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

In CFFormula is: =IsFormula(cellref)


Gord Dibben MS Excel MVP


On Mon, 30 Apr 2007 11:32:01 -0700, nastech
wrote:

Hi, is there a formula for cond. format, if cell is formula / not a formula,
then no formatting / background color. this would occur if typing a number
in place of formula. thanks