Select the range A3:A250

Goto FormatConditional Formatting
Select Formula is
Enter this formula in the little box:

=ISNUMBER(SEARCH(LOOKUP(REPT("z",255),D:D),A3))

Click the Format button
Select the style(s) desired
OK out

Biff

"ebraun01" wrote in
message ...

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