Forum Discussion
KellySingleton
Sep 13, 2021Copper Contributor
Conditional formatting for comparing cells
I have a 2000+ row spreadsheet that I have columns that compared with v-lookup. I copied and pasted values for the lookup in a new column and now I need to highlight the rows that don't match. I have tried conditional formatting with the add new rule>Use a formula to determine which cells to format and the formula I use is =$A:$A<>$B:$B and click OK (I don't care what the colors are). It isn't working. There are obvious differences, but none of my cells are highlighted.
The sample I have loaded contains 18 rows of the spreadsheet and I need to compare columns A to B and highlight each row that is different...ie A3 is obviously different than B3. I would like to create a rule that would compare A3 to B3 and let me know that it is different so I can go change it in a database.
I hope I am clear on what I want to do
7 Replies
Sort By
- Juliano-PetrukioBronze Contributor
The Column B "visually" looks the same values of Column A
But you have a lot of "extra" blank spaces on column B.
So in this case is recommended remove these extra spaces by using the TRIM() formula.=ISERROR(MATCH(TRIM($B1),$A$1:$A$19,0))
- KellySingletonCopper ContributorI ran the formula but then how do I get the cells highlighted?
- Juliano-PetrukioBronze ContributorHave a look on the attached file.