Help with Conditional Format

  • Thread starter Thread starter Charles Reid
  • Start date Start date
C

Charles Reid

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
 
What do you mean by "change the Member list"? This might mean you
a) alter an existing entry
b) extend the list by adding new names; AND altering the definition of
Members
I cannot duplicate your problem - both (a) and (b) work for me
Please give us more info so we can help
best wishes
 
Back
Top