Hi,

I have a worksheet and I need excel to automatically highlight a cell when the value has been changed by a user. This rule would need to cover specific ranges of data.

I have looked at the excel Track Changes tool but due to the complexity of the spreadsheet it cannot be shared.

So for example if any cell value in range F25 to FF25 has it's value changed then the background colour of the cell should change to red. I would then use the same macro cover the same cells in rows 32, 39 46 etc.

Any help on this would be appreciated.