Assuming that A2:D4 contains the data, try...

1) Select B2

2) Format Conditional Formatting Formula Is

If the relevant information for Column B is always the last 3 characters:

=MATCH(RIGHT($B2,3)+0,$D$2:$D$4,0)

Otherwise:

=LOOKUP(9.99999999999999E+307,FIND($D$2:$D$4,$B2))

3) Choose 'Format'

4) Select the desired formatting

5) Click Ok twice

6) Copy the formatting to the other cells...

Copy Paste Special Formats

or

Format Painter

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

In article ,
narp wrote:

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