Is there a way to have 2 worksheets with identical data on both and if there is a change on one of the sheets (lets call it 'master') that the row on the other sheet will change colour for that whole row or if easier just the corresponding cell?

Thanks
Debbie