I've been working on a sheet that helps me track matching numbers. I used the MATCH function using custom conditional formatting. To help me track easily, I want the cells to be highlighted when the value matches with the other column (column B and column I).

My first attempt was not successful since it did not highlight anything (see sheet: 1st attempt). So I tried to add another column (column J) hoping it will work. It kinda worked but not the way I wanted to (see sheet: 2nd attempt).

The format in Column B seems to be a NUMBER. The format in Column B seems to be a TEXT. The format in Column B seems to be a NUMBER.

I am really confused and stuck now on what to do next. Your help will really be appreciated. Thank you!

Here is the link to the document in case you want to have a glimpse of it. It is editable, btw.

CodePudding user response：

Added solution CF to your