Hello,

I think I can help with this. I have attached the workbook with the updated conditional formatting rule that I used to highlight the duplicate values to your first table.

If you go into the conditional formatting rules, you can see the formula that I used.

Instead of using the duplicate value setting, I thought it would be easier to write my own.

The formula that I used is:

=$B3=$C3

Think of this as an IF statement. IF B3 = C3, then fill in with whatever color you want.

Let me know if you have any other questions!