Try this:

From the Excel main menu:
<tools<options<error checking tab
Check: Enable background error checking
Check: Inconsistent formula in region

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Dean" wrote:

I seem to recall that there is some feature in EXCEL that will alert you to the fact that a cell's formula appears different from that of its neighbors. For example, if you copied a formula across a row and then, for testing purposes, overwrote one of the cells with a value, then forgot to change it back to the formula, it would alert you to that.

Can anyone remind me of what that might be?

Thanks!
Dean