Works like a charm.
I never get tired of suggestions. That is the way we learn.

Thanks Gord

--
Thank You in Advance
Ed Davis
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You may be tired of my suggestions by now Ed<g

Copy this UDF to a general module.

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

FormatCFFormula is: =NOT(IsFormula(A1)) Format to a color.

When a formula is overwritten with a number, the cell will change to the
chosen color.


Gord Dibben MS Excel MVP

On Wed, 7 Oct 2009 07:42:30 -0300, "Ed Davis"
wrote:

Is there a way to conditional format a cell that does not have a formula.
It does not matter what the formula is as long as it does not have one.
I allow users to overwrite formulas but would like to be able to see what
ones were over written with a number.
I tried using ISNUMBER but even if it is a formula it returns TRUE.