I was watching one of Mike Girvin’s excellent Excel videos today. The technique demonstrated in the video was to use Power Query to extract items in list 1 that are NOT In list 2:
https://www.youtube.com/watch?v=JztEKJ-XkCU
I realized that this was the opposite of the conditional formatting technique I had just published.
So, for the sake of completeness, I decided to modifyvmy technique to emulate Mike’s technique.
Only a minor modification of the the CF formula was neccesary to produce the opposite condition.
=ISERROR(FIND(CONCAT($A2:$E2),CONCAT($I$2:$M$6)))
You can see the results in the following figure.
You can download the example file here.
Pingback: #Excel Super Links #100 (Special Edition) – shared by David Hager | Excel For You
Pingback: #Excel Super Links #138 – shared by David Hager | Excel For You