Comparing two columns of data and Highlighting the Differences

  • Thread starter Thread starter Harapa
  • Start date Start date
H

Harapa

I have values (mix of text and numbers)in column A and B. Each cell
value in column B is also in column A. I want to highlight (Change
Fill color to Red) for example) all those cells in column A that are
also present in the column B. Any help writting a Macro will be highly
appreciated. Thanks in advance.
Harapa
 
No macro needed. Select Column A's Data. Use Format/Conditional Formatting.
Change "Cell Value Is" to "Formula Is"
Assuming A1 is the active cell, enter this formula:
=NOT(ISERROR(MATCH(A1,$B$1:$B$500,0)))
click Format, click Patterns tab, select Red fill pattern.
Click OK till you're out.

Bob Umlas
Excel MVP
 
You can use conditional formatting. While in cell 'A1'
Click Format/Conditional Formatting.
Choose 'Cell Value is' and 'equal to' and enter =$B1.
Choose a format and click OK.
While still in 'A1' Click on paint and paint down the
number of cell necessary.

Charlie O'Neill
 
Thanks alot. It did it.
Harapa.
Bob Umlas said:
No macro needed. Select Column A's Data. Use Format/Conditional Formatting.
Change "Cell Value Is" to "Formula Is"
Assuming A1 is the active cell, enter this formula:
=NOT(ISERROR(MATCH(A1,$B$1:$B$500,0)))
click Format, click Patterns tab, select Red fill pattern.
Click OK till you're out.

Bob Umlas
Excel MVP
Click to expand...
 
Back
Top