Highlight EXACT matches with Conditional formatting

[panyagak]

hi ALL.

Am lost in this.

To simplify, given 2 long non- contiguous columns A & B only in only one ws and using Conditional formatting approach, am lost on how to proceed with highlighting identical entries.

Eg
colum A = A2:A55000
column B = B2:B234000

thanks

 

[jasonb75]

Perhaps you could just select both ranges, then use the highlight duplicate values rule from the conditional formatting editor?

 

[panyagak]

Perhaps you could just select both ranges, then use the highlight duplicate values rule from the conditional formatting editor?

the purpose being identifying any Coln A entry that matches an entry in Coln B, you mean that?

 

[jasonb75]

You asked for identical entries, it will highlight any entry that appears more than once, that could be 2 entries in column A, 2 entries in column B, or 1 entry in each column.

If that is not what you want then you need to be clearer with your question.

 

[panyagak]

Thanks.

Another corollary quizz to my earlier one: is there a way to delete Unhighlighted cells' rows???

I just couldnt make of selecting unequal ranges....I just read this: How to Select Non-adjacent cells in Excel? (4 Easy Ways) - Trump Excel

READING IS NICE!!!

Regards

 

[panyagak]

My question answered #5, if not self-answered:

How to remove non-highlighted cells in Excel?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com

great y'all