zhshqzyc
asked on
Highlight the difference (VBA/Formula)
Please see the attached file. If the cells in cloumn A and B are different, please color it.
I have thousands rows.
Book1.xls
I have thousands rows.
Book1.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can select as many cells as you would like, up to full columns. If you want to select just cells A2:B5873, that would be OK. You would then apply conditional formatting to the selected cells using the formula:
=$A2<>$B2
If you have already applied conditional formatting to the entire column, you may find it easier to remove the conditional formatting from cells A1 and B1. To do this, select A1 and B1, open the Conditional Formatting menu item, choose Clear Rules and then choose Clear rules from selected cells.
=$A2<>$B2
If you have already applied conditional formatting to the entire column, you may find it easier to remove the conditional formatting from cells A1 and B1. To do this, select A1 and B1, open the Conditional Formatting menu item, choose Clear Rules and then choose Clear rules from selected cells.
ASKER