Conditional Formatting for Unique IDs in Columns

Hi,

I have 2 columns with one column (column 1) having a series of unique IDs. The other column will have the same IDs, plus additional IDs & may be repeated several times.


I'm seeking a conditional format function for column 2 that will highlight matching IDs found in column 1 or my primary set of IDs.

If possible, it would also be nice to have some type of automation that will give a unique or specified color for each unique ID matched.

How can this be done?

Thanks

The unique colour thing is not really easily possible.

You can have a single colour with formula:

Invoke conditional formatting and use formula:

=MATCH(B1,A:A,0)

where B1 is top most cell you selected in column 2 and A:A is column A where you want to see if there is a match somewhere.

If you want you can apply a formula in another column that will tell you the position the match was found within column A, that will help you find them...

=IF(ISNUMBER(MATCH(B1,A:A,0)),MATCH(B1,A:A,0),"")

copied down

Hi NBVC,

Both of these functions work great!!

Thanks