Again: Highlight the cell/row if particular name comes..

[vinu]

Hi,


This was already posted but not got any attantion, So posting it agail

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


Regards,


Vinu...

 

[Squeaky]

It is not clear what you are asking. Are you wanting certain words in certain
cells to go bold or change color when certain people's names are entered?

Please clarify your question.

Squeaky

 

[bala_vb]

Hi,


This was already posted but not got any attantion, So posting it agail

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


Regards,


Vinu...

I think you are looking if name repeated (duplicate) in the column B.
Use conditional formating
=AND(COUNTIF(B:B,B2)>1)

I have attached sample spread sheet. please refer to it.

similarly you can apply conditional formating across the row.

all the bes

+-------------------------------------------------------------------
|Filename: Sample.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=142
+-------------------------------------------------------------------

 

[vinu]

Hi Squeanky,

Great that you understood my confuting post...

What I exactly wanting is that certain words(area names) in certain
cells to go bold or change color on a perticular sheet when the whole
of data was pasted...

Pls help...