Forum Discussion
Highlight cells that contain typos
I need to highlight cell values that don't match a set of values that are in another column. The values repeat multiple times in one column and only once in other column. Basically I want to look for...
Select column B then in conditional formatting select add new rule and then select "Use a formula to determine which cells to format".
In the formula bar type: =ISERROR(MATCH(B1,$AA:$AA,0))
Click the Format button and select how you want the highlighting to look.
Lastly, I would recommend inserting the Title of column B into column AA so that cell B1 isn't highlighted.
In the formula bar type: =ISERROR(MATCH(B1,$AA:$AA,0))
Click the Format button and select how you want the highlighting to look.
Lastly, I would recommend inserting the Title of column B into column AA so that cell B1 isn't highlighted.