I have a list of names in the following format:

First Last Apt# First Last Apt# First Last Apt#


In other words three columns of names with their Apt#.

Is there a way to color conditionally format the first/Last/Apt# given
that the apt# can be named 100-326, 5000-6400 plus a "LL", "CMU", 540A thru
540P. Since there are more than 3 conditions I can't use normal conditional
formatting. Also since there are numbers and letters for the apt names, I
can't use Case Select (or can I some way?). Plus I would like to have all 3
columns (First-Last-Apt# color coded based on the Apt# color code. And it
would have to work for each set of 3 columns of names.

Any ideas? Thanks

Good morning Jim Brass

You can use the add-in below to conditionally format cells with 30
conditions avalable.

http://www.xldynamic.com/source/xld.....Download.html

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=486475