I have a sheet displaying some water quality values, and for most of the cells I have the numbers displaying a calculated value. But once in a while I actually measure the value, and type in the measured, rather than calculated, number in the cell. I'd like the cells to automatically display the number as black when it is pointing to the calculation, but red when I type the number in. How can I do this?
Thanks!
Sean
Bookmarks