Tom’s Tutorials For Excel: Monitoring Changes in Data With Conditional Formatting
Without any programming involved, you can monitor a workbook for cells that were changed from their original values.
In the first set of pictures, range B5:B8 is being monitored by Conditional Formatting in hidden columns D:E.
Alt+O+D calls the Conditional Formatting dialog box, shown in the second set of pictures with the formula rule
=E5<>B5 to color cells that contain different values than their relative cells.
Leave a Reply