I had refeneced J's in one of my replys and when I change all the j's to DJ's
it works!!! Yeah!!!

Thank you soooo much!!!! :)
--
narp


"Don Guillett" wrote:

Modified for your data. Try it

Sub highlightmatches()
Dlr = Cells(Rows.Count, "D").End(xlUp).Row
blr = Cells(Rows.Count, "B").End(xlUp).Row
Cells(1, 1).Resize(blr, 3).Interior.ColorIndex = 0
For i = 1 To Dlr
ml = Len(Cells(i, "d"))
For j = 1 To blr
If Right(Cells(j, "b"), ml) = CStr(Cells(i, "d")) Then
Cells(j, "b").Interior.ColorIndex = 6
End If
Next j
Next i
End Sub

-- Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
Did you try my macro?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"narp" wrote in message
...
That didn't work either. It highlighted the column from the next row
down.

Thanks for the help!
--
narp


"Jacob Skaria" wrote:

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