Help with Conditional Format

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top