I think this will work fine. I appreciate all that you put into it. One
Question, How do I get the conditional formatting to work on column A
also? I adjusted the forumula so it finds matches in that row..but the
conditional formatting does not work.


--
ebraun01
------------------------------------------------------------------------
ebraun01's Profile: http://www.excelforum.com/member.php...o&userid=30340
View this thread: http://www.excelforum.com/showthread...hreadid=500035