How do I highlight duplicate entries in one table column from entries in another table column in a different tab?

HI shaundra,

Conditional highlighting requires comparing the contents of the cell to be highlighted with another fixed value (written into the CH rule) or contained in another cell (named in the rule).

You want to highlight entries that match 'any' value in a range of cells, which is not an ability written into conditional highlighting. But you can search the range of cells for a match, and use that search to change the value in a specific cell, providing a single cell for the highlighting rule to monitor.

For the example, I've named the 'larger table' All and the smaller, entry table "some". For ease of filling ALL, i've restricted the values to a set of letters followed by a serial number. This restriction does not apply to your tables.

Formula in ALL::B2 and filled down is:

IF(COUNTIF(Some::A,A2)>0,A2,"")

This column may be hidden.

Regards,

Barry

.

On way is to do something like this:

=COUNTIF(Table 2::A,A2)>0

All the entries in Table 1 that are already in Table 2 will be marked TRUE. You can filter on that column if you want.

It's easier to set this up on one sheet (tab). After you've got it working you can try copying Table 1 to another sheet if you need them on separate sheets.

SG