Dear all

I have in :

-- Column A, a list of items say,


1 YORK A/COND
2 SANYO 1.0HP air-cond
3 CANON laser printer (model : L-P'TER*LBP-3050)
4 EPSON - Batching system printer
5 EPSON - Dot matrix printer
6 Nokia 1200 - handphone
7 HP printer
8 Panasonic K Printer
9 Panasonic X printer
10 Panasonic P-P1121 printer
11 Nokia N6070 handphone
12 Nokia 1200 handphone
13 Microphone
14 Panasonic printer
15 2nd hand hand phone

I am looking for a function / vba / anyway if excel can do a pattern
match
and :

- highlight (with color) items 1,2
and return in column B the word "cond" (i.e. same word contains in
both the the items)

- highlight (with different color) items 3,4,5,7,8,9,10,14
and return in column C the word "printer" (i.e. same word contains in
all these items)

- highlight (with different color) items 6,11,12,13,15
and return in column D the word "phone" (i.e. same word contains in
all these items)

Any suggestion or help on this is greatly appreciated.

Thanks heaps ! Everyone.
SauQ