Home > Software engineering >  Highlight cells based on another cell's value through conditional formatting
Highlight cells based on another cell's value through conditional formatting

Time:01-19

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. enter image description here

  • Related