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