Previous Topic Next Topic

Comparing columns in Excel 2010

[Solved/Closed]
Report
Posts
1
Registration date
Friday November 13, 2015
Status
Member
Last seen
November 13, 2015
 -
 laulou95 -
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

1 reply

Answer 1 / 1
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
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
Report

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.
Ask a question