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
It looks all correct.
I made a small change on your file to optmise it.
Your file is very big even with a small quantity of data.
The main reason is because you expanded the formulas to the all rows of the spreadsheet. Plus than1 million rows (1,048,576).
- Got it - Thanks