Highlight cells that contain typos

Copper Contributor

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 typos and highlight them.  I want to search column B for typos using the AA column as point of reference. If the value in column B doesn't match the value in the AA column it won't calculate the values correctly.

 

Thank you,

Amy Fair

1 Reply
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.