Forum Discussion
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.
Is there a way to flag entries with identical dates and amounts?
Many thanks
Richard
2 Replies
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
Many thanks Sergei.
That'll keep me quiet for a while!
