I've been working on a sheet that helps me track matching numbers. To help me track easily, I want the cells in column B ang G to be highlighted when both value matches.
I tried different ways with conditional formatting. I think it is something doable, but I just could not figure it out after several times. It kept highlight the wrong cells.
The format in Column B and G seems to be a NUMBER.
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. I added my 3 attempts in the sheet so you can see it. The file is editable.