Forum Discussion
Richard Tierney
Apr 04, 2017Copper Contributor
Compare and Highlight Identical Values
Help please. I have an annual accounts spreadsheet, with a tab for my bank transactions and another tab for cash. I have noticed that a few bank entries are duplicated on the cash sheet. ...
SergeiBaklan
Apr 04, 2017Diamond Contributor
Hi Richard,
Please check this Highlight unique values. That's an opposite to your one task, but perhaps it will help.
UPDATE
Oops, i forgot - in Conditional formatting there is the direct action from menu Highlight Cells Rules -> Duplicate Values
Richard Tierney
Apr 04, 2017Copper Contributor
Many thanks Sergei.
That'll keep me quiet for a while!