How to track updates in an Excel worksheet

Let's say we share a worksheet with other team members and the data here is updated. How do we keep track of the updates? Using a named range and conditional formatting we can easily keep track of who has changed what and also compare the data with the original data.

1. The first step is to copy the data and paste it another worksheet in the same range. So if your data in one sheet was in the range C3 to D8, then the copied data must be place in the same range.
2. Now we select the data in cell C4 in the sheet 2 and give it an appropriate name like 'original'. The reference should be a 'relative' one as shown in the training video.
3. Now we go back to our sheet1, select the same cell c4 and apply a conditional formatting. Here we apply a formula like '=C4>original' and '=C4 less than original' and apply different formatting styles to check for the changes in different directions.
4. Now we use the format painter to apply the conditional formatting on all the relevant cells. The formatting is not applied to the headers.
5. Now if the data is updated in sheet1 it takes the applied formatting and the changes can be tracked immediately