Forum Discussion

Richard Tierney's avatar
Richard Tierney
Copper Contributor
Apr 04, 2017

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

Formulas & Functions
Requests

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 04, 2017

    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

Resources