Tom’s Tutorials For Excel: Monitoring Changes in Data With Conditional Formatting

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.



Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

*