--In the text box ''Format values where the values are true'..copy and paste
the below
=FIND(D1,B1)

--Click Format ButtonPattern and select your color (say Red)

-- Hit OK

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


"narp" wrote:

I got that far, but dont know how to write the formula. Thanks!
--
narp


"Jacob Skaria" wrote:

--Select the Column B
--Conditional FormattingHighlight Cell rulesMore rules
--Selet the last option from the list
'Use a formula to determine which cells to format'

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


"narp" wrote:

I'm not getting it to work.

Here is my data sample:
Date Number c Processing
06/14/09 EC17251 34002
07/20/09 EC17570 17251
08/07/09 EC17716
07/15/09 OR33889
07/16/09 OR33956
07/17/09 OR34002
07/22/09 OR34178

I went to the New Formatting Rule as directed but don't know what to enter
in the "Format values where this formula is true:" box. I want it to lookup
info in column D and if it is found in column B then highlight that cell.
For example, Does a cell in Column B contain the info that is found in any
cell in column D--otherwise written as: does 34002 (cell D2) show in any cell
in column B (cell B7) and if so highlight cell B7.

Sorry for the confusion. Thank you for your assistance.

--
narp


"Jacob Skaria" wrote:

Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format

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


"narp" wrote:

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