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