Thanks to all ... all seemed similar to answer I found somewhere else and
ended up using.

Created a general module in VBE for the workbook:
Function IsFormula(Cell)
IsFormula = Cell.HasFormula
End Function

Then used conditional formatting:
CF-Formula Is-=NOT(IsFormula(CellRef))

Hope that helps for others as well!

Heather


"HeatherT" wrote:

Hi,
I'd like a cell to change color when a user has entered a hard-coded number
rather than the keeping the formula already in the cell.
Any ideas?

Thanks,
Heather