I have applied an advanced conditional format to a range of data, to highlight those cells which are duplicates. There are 3 sets of criteria, which are explained in the attached file, but in short, the following criteria must be met:
1. The first cell in the column indicates whether it is critical for this column to identify duplicates
2. The cells are non-blank. (If there are multiple cells that are blank in this column, I want them to be ignored).
3. There are EXACT duplicates (case-sensitive) with this column.
It works as expected until there is a filtered applied. I need the conditional formatting to be applied to duplicates in the VISIBLE cell only.
The table regularly shrinks and grows, as new data is copied/pasted into this table. the conditional formatting must be dynamic, as it applies to different numbers of rows. I expect this will work smoothly, since it is contained in a table, which will auto-expand.
Could someone provide assistance to this problem?
Bookmarks