My thoughts on this is to create a copy of the worksheet and then protect and
hide it. When it is returned a macro could be used to compare the data on the
returned worksheet with the data on the copy and color any non matching cells.

Would this meet your requirements?
Would you like me to write a macro for you? If so then what version of xl
are you using?
What is the range of the data to be checked? That is from cell A1 to ????.
There are ways of finding the last cell but if it is always within a fixed
range then that makes life easy.
Do you need instructions to copy the macro to the workbook and run it?
Could also create a worksheet with a list of the changed cells with the old
and new values.

Regards,

OssieMac

"FARAZ QURESHI" wrote:

Can u write a code to highlight a cell with any color if its value is
changed. Actually I am working at a Head Office and am collecting data from
branches on a sheet that I am distributing however I have to keep a check if
the original values have not been changed.

Please consider the example:

Action 1:
Cell A1 has a value "5" if someone turns it to "6" the cell turns to Red.
Action 2:
Upon a realizing that he has made a mistake if he turns it back to "5" the
cell is no longer highlighted.

If it even doesn't work the second time, that is reverting back to
non-highlighted, even a code for only the first action would also be higly
obliged.

Thanx!