Hi,

You may use this formula in conditional formatting
=ISNUMBER(LOOKUP(2,1/SEARCH(D20,$B$20:$B$22))). Apply a format of your
choice and thencopy paste the conditional formatting down.

Do let me know how this works

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"narp" wrote in message
...
How can I create a function that will highlight a cell in Column B if the
cell info contains the info in Column D? Info in Column D is not always
aligned with info in Column B.

A B C D
06/17/09 OR123 1.00 123
07/01/09 EC458 2.00 528
07/01/09 OR528 15.00 924
--
narp