Hi,

This is what I would like to achieve,

There will be sheet full of address details and in that I want to
highlight the cells with some colour if the particular list(i.e.list
of 10 particular area names like Area1,Area2....Area10) of area names
present along with the door # and Street name.

The challenge is that the area names will be mixed with street name
ect., in the same cell.

I can guess that this is possible with macro but my knowledge in that
is ZERO..

Pls help on this...