If you are you looking for ONE item use FIND and then
Sub findandhilite()
Columns(2).Find(1).Interior.ColorIndex = 3
End Sub
if mor than one look at the example for FINDNEXT and use the same idea


--
Don Guillett
SalesAid Software

"Rick .<" wrote in message
...
Hi everyone,

As Excel can't highlight what you have found using 'Find', is there any
other way to achieve this outcome? I used to copy and paste them to Word
but
now the data gets to large and my Pentium 4 computer can't cope!

Thx