It sounds as if knowing whether that cell has a formula is what you are
asking for. If you can use a UDF, the following seemed to work for me:

Function IsFormula(myRange As Range) As Boolean
If myRange.Range("a1").HasFormula Then IsFormula = True
End Function

and on the spreadsheet:

=isformula(C37)
returns either true or false
"scott" wrote:

I have a cell that has a formula entered into it. At certain times in the
month of operations this cell with the formual needs to be replaced with a
meter reading. I have the worksheet protected expcept for this cell so people
can enter in the reading.ow is there another formual or way to tell when this
formula has been replaced with the reading, maybe in the form of another
formula in another cell.
Thanks in adavance
Scott