Looks like the CF issue with trying to select a group of cells based on CF
shadings isn't going to happen.

So maybe I'll try a different avenue.

I'm using range A2:A27.
Cell C29 is populated by a ListBox.
The value in C29 will correspond to a Named cell range.

I'd like to find a way to compare each cell in the range to each cell in the
Name range. Range A2:A27 will have all the items that are in the defined
Name range. However, the defined Name range will not necessarily have all
the items that are in A2:A27. Whichever items were missing, I need to have
them selected.

Would this be done easier?

Thanks,
Paul