Related:
- Comparing columns in Excel 2010
- Compare two columns in excel for partial matches - How-To - Excel
- How To Compare Two Columns in Excel - How-To - Excel
- Excel - Compare column A & B give results in column C - How-To - Excel
- How to compare one cell with entire column in excel - How-To - Excel
- Compare the words in 2 columns in Excel ✓ - Forum - Excel
1 reply
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- How to Recover Your Yahoo Account
- How to Disabled Write Protection on a USB
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- Facebook Code Not Received
- How to Get More Followers on Instagram
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.