Comparing columns in Excel 2010

Solved/Closed

Laulou95 Posts 1 Registration date Friday November 13, 2015 Status Member Last seen November 13, 2015 - Nov 13, 2015 at 06:38 AM
laulou95 - Nov 22, 2015 at 11:15 AM

Hello all:

I have an excel spreadsheet with 95 columns. I want to compare column 1 to column 95 and highlight in column 1 any line item that is missing from column 95, then compare column 2 to column 95 highlighting in column 2 any line item missing from line 95 continuing to lines 94 and 95. Can you provide me with a solution?

Thank you

Comparing columns in Excel 2010
Microsoft office 2010 free download full version with key - Download - Office suites
Excel date format dd.mm.yyyy - Guide
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
Number to words in excel - Guide
Screenshot in excel - Guide

1 reply

Answer 1 / 1

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Nov 13, 2015 at 10:00 AM

You can use conditional format
So If you click on A1 and then select all columns till column CP
and use the formula
=AND(A1<>"", ISERROR(MATCH(A1,$CQ:$CQ,0))) and select the color you would like to see

laulou95
Nov 22, 2015 at 11:15 AM

Thank you rizvisa1
I used the conditional formatting comparing each column individually to column A. the formula was not exactly what I had in mind. However, it was very effective for another part of the project.

Thanks again.

Subscribe To Our Newsletter!