Forum Discussion
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...
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))
- I ran the formula but then how do I get the cells highlighted?
- Have a look on the attached file.
I must have something else wrong when I converted the formula to the actual worksheet. Not all of the non-matching cells highlighted. ie G3 & H3 or G4 & H4. See attached. Juliano-Petrukio
