Prev: modifying name format within a cell
Next: Insert extra lines
From: vinu on 29 Apr 2010 16:01
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...
From: Pete_UK on 29 Apr 2010 19:18
Can you give us some examples of what your data looks like, and
details of what columns you use etc.

Pete

On Apr 29, 9:01 pm, vinu <vinup...(a)gmail.com> wrote:
> 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...

From: vinu on 30 Apr 2010 09:58
Hi,

Actually the work book will have a shift wise rostered to be given to
the transport providers.

separate sheets were maintained for every shifts(28sheets) and there
will be details of the resource and his/her address ect.,

The address details will mostly end up in C column. In address column
the area details will be there (in below e.g. I typed the area in caps
just to differentiate it from other words). Out of 100 areas(approx)
there is 10-15 Areas that I want the end user to notice right away as
it has to be given some spl attention.


A B C
1 Gender NAME ADDRESS
2 M Johnson Rajendran 1P Station view Apartments No.30 Railway Border
Road,KODAMBAKKAM
3 F Jeyalakshmi Ramachandran 16/2 sreenath flats postal colony 2nd
street WEST MAMBALAM



Hope I'm bit clear this time...



Regards,

Vinu...
 | 
Pages: 1
Prev: modifying name format within a cell
Next: Insert extra lines