View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vinu vinu is offline
external usenet poster
 
Posts: 9
Default Again: Highlight the cell/row if particular name comes..


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...