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
laulou95 - Nov 22, 2015 at 11:15 AM
Related:
- Comparing columns in Excel 2010
- Microsoft office 2010 free download - Download - Office suites
- Pdf and xps add in 2010 - Download - Other
- Number to words in excel - Guide
- Gif in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Nov 13, 2015 at 10:00 AM
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
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
Nov 22, 2015 at 11:15 AM
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.