Forum Discussion

Connor McGuigan's avatar
Connor McGuigan
Copper Contributor
Oct 31, 2018

Conditional formatting to show all the non-matches between two ranges?

I have two named ranges, "AllVNs" and "JanVNs." They have a lot of overlap, but I need to find the values in JanVNs that AREN'T present in AllVNs. I tried the advanced filter, but it doesn't seem to ...

Resources