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.
Pressing 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