Forum Discussion

Amy_Fair's avatar
Amy_Fair
Copper Contributor
Jul 13, 2021

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

excel

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Jul 13, 2021
    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.

Resources