Why not just train people not to do that?

You could write some complicated VBA code that checks the content of a
cell to see if it contains hard coded values. In the Worksheet_Change
Event, it could act as a realtime monitor. There are also some
spreadsheet auditing programs that can do this for you. Check out:
http://arxiv.org/ftp/arxiv/papers/0803/0803.0169.pdf



HTH,
JP

On Jul 14, 2:55*pm, Steve wrote:
Hi all,

I need some help. *I'm looking for a way to do this. *I have columns with
formulas. *And sometimes those formulas in a particular cell or 2 are
overwritten with a "hard" number. *Is it possible to somehow make it so that
when someone changes the cell to a number that it turns the cell yellow
automatically?

Please help.

Thank you!!