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:
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.
You can see the results in the following figure.
You can download the example file here.