Bif,
Thanks for the help. It isn't quite working.

I named the range on my customer list. I then name the range on my
critical list. I tried conditionally formatiign both. and it doesn't
work. I think the problem might be that the values are not exactly the
same from one sheet to the other.

example customer list shows customer name (customer identifier)
critical list only has custoemr name. customer identifiers can vary
depending on the type of account so they are not a constant and
can/will vary between the same custoemr on different outages depending
on the service impacted.

Bobs tires could have a location in NY with an ID of g47 and another
loc in PA with and ID of M52.

So for a customer list on a NY outage cell A10 would reflect Bobs Tires
(G47).

I have no Access to the databases needed to locate all the customer
id's.

Is this the variable that's holding me back? Is there a formula that
will let me conditionally format less than a complete matching entry?


--
wolfsburg2
------------------------------------------------------------------------
wolfsburg2's Profile: http://www.excelforum.com/member.php...o&userid=29866
View this thread: http://www.excelforum.com/showthread...hreadid=495703