This seemed simple a few hours ago.
A log of invoice details MAY contain duplicate entries. If the columns for INVOICE and DATE and AMOUNT on one row are repeated on another row, the duplicates need to be highlighted. Highlight can be applied to any or all three columns or even the entire row.
Duplicates in any one of the three columns is common (even Invoice number). It is when the same value appears in all three columns in multiple rows that a duplicate invoice has been entered and highlighting is needed.
Alternatively, I could use an IF and COUNTIFS formula but that would take up an extra column, but I would prefer conditional formatting if possible...or possibly a VBA solution.
Thanks for your time.
Bookmarks