highlighting on a change
 

Hi,

I want to be able to trigger highlighting of a corresponding cell if
one from another sheet changes. Then, after a second user has
identified the changed cells and made other changes to spreadsheet, I
want to clear the changes.

for instance....I have a scheduling tab and an dispatch tab. If a time
is changed in the scheduling tab, a corresponding dispatch zone and
route sequence needs to be altered by another person.

so schedule: Zone Sequence Mon Tues Thurs
2 1 1 pm 1pm 1pm
2 2 3 pm 3 pm 3 pm

dispatch zone sequence time employee1 employee2
2 1 1 pm xxxx
xxxxx
2 2 1 pm xxxx
xxxxx

so user has changed sequence 2 on schedule tab, and I need it to flag
sequence 2 on dispatch tab.


can this be done?