You might be able to just use Conditional Formatting for this, under the
condition that you only have 4 conditions (or fewer).

You first need to name the cells containing the account names. Then
your conditional formating would read:

If cell value is equal to =-target name-

You have to use named ranges, because Excel won't allow you to refer
directly to cells in another sheet for conditional formatting.

If you make all your ranged cells the format of one of the 4
conditions, you can then add 3 more conditional formats to those cells,
for a total of 4. If you can't start out with one of the formats, you
can only do 3 conditional formats.

Hope this helps.


--
BruceP
------------------------------------------------------------------------
BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653
View this thread: http://www.excelforum.com/showthread...hreadid=539569