Comparing columns in Excel 2010
Solved/Closed
Laulou95
Posts
1
Registration date
Friday 13 November 2015
Status
Member
Last seen
13 November 2015
-
13 Nov 2015 à 06:38
laulou95 - 22 Nov 2015 à 11:15
laulou95 - 22 Nov 2015 à 11:15
Related:
- Comparing columns in Excel 2010
- Microsoft picture manager 2010 - Download - Image viewing and management
- Ms office 2010 free download - Download - Office suites
- Pdf and xps add in 2010 - Download - Other
- Excel mod apk for pc - Download - Spreadsheets
- Arrow keys not working in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
13 Nov 2015 à 10:00
13 Nov 2015 à 10:00
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
22 Nov 2015 à 11:15
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.