In column A, I have a value and I want to highlight if it doesn't match the same value in column B.
I'm using the formula below in conditional formatting which works great.
After highlighting them, I need to be able to sort/filter by cell colour so I can easily find non-matching rows.
However as my data is often 60k+ rows, this often makes Excel freeze up and/or crash.
I know conditional formatting adds a lot of weight to a spreadsheet, so what lighter alternative is there for what I'm trying to do?