Hello Excel Guru's,

I am trying to cross out any names that do not appear in a list using
conditional format.  I have named the list Members.  Listed below is my
sample list:

A     B                  C                      D
1     Spiderman        Batman         Superman
2     Hulk                 Vision           Cyborg
3     WonderBoy     Hawkman     GreenArrow

C2:E4 is named Members

In another column I have the following list:

A     B
1     Name
2     Iceman  <-- Strikethrough not in above list
3     Firestar  <-- Strikethrough not in above list
4     Spiderman
5     Robin  <-- Strikethrough not in above list
6     Hulk
7     Batman
8     Superman
9     Cyborg
10   GreenArrow
11   Rogue  <-- Strikethrough not in above list
12   Beast  <-- Strikethrough not in above list
13   Hawkman

The formula that i have in for my conditional Format is the following:

=countif(Members,B1)=0
(with format of strikethrough and color red)

This appears to work fine for the first time through, but if I close and
exit out of the spreadsheet and start again, it doesn't work when I change
the Member list.

How can i get it so that if I make a change to my Member List, it
automatically updates the current list and stikesthrough the names that do
not appear in that list.

Thanks in advance