See this:

http://groups.google.com/group/micro...cf859ecd?tvc=2

--
Biff
Microsoft Excel MVP


"HeatherT" wrote in message
...
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