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
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