I have an excel spreadsheet containing two columns.
I use the
EXACT function to determine if, for example if
The function returns true/false in another cell.
However, I am looking to highlight the original cell that matches/do not match. In this case if
A2.equals(B2) evaluates to false, the cells being checked, A2 and B2, are highlighted, how would I go about doing this?