Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You can use conditional formatting to highlight cells that are not identical between the two sheets.

Select cell range on the first sheet. Then Format, Conditional Formatting, Condition... Cell value is, not equal to, and in the empty box select the first cell of the range on the other sheet. Remove the $ from the cell reference of the other sheet in the box. Choose New Style from the drop down box and set a highlight color for cell background.