I forgot to say I am using Excel 2007. Where do I find the conditional
format that allows for multiple conditions. Also to clarify, I want to look
for info in cell J2 within the range of column b (b1.b200).
--
narp


"Jacob Skaria" wrote:

1. Select the Column B
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=FIND(D1,B1)
4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"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
--
narp