Sorting names from a list

  • Thread starter Thread starter rkumar
  • Start date Start date
R

rkumar

I want to highlight all names in a particular column, say column A
starting with an alphabet value, say t, placed in a cell in anothe
column, say B2. So, names are listed in column A, B2 contains t. I wil
like to color all cells in column A that contain names strating with t
I would actually prefer to create a macro. Any help will be mos
welcome. Thanks
 
Hi rkumar,

Can't help you with a macro but this is very easily done
with conditional formatting.

Select the range to apply this to.
Select Conditional Formatting
Formula Is =LEFT(A1,1)=B$2
Select the type of formatting you want.
OK out.

Biff
 
In case there might be blank cells in column A, change the
formula to:

=AND(LEFT(A1,1)=B$2,A1<>"")

Biff
 
You can use AutoFilter
Ctrl+A, Data, Filter, AutoFilter
click on the dropdown in column B and select T

to unfilter, Data, Filter, turn off AutoFilter

If the data is sorted in alphabetical order you could
use a doubleclick Event macro to locate yourself
to the t's by enter t into the offered inputbox
http://www.mvps.org/dmcritchie/excel/event.htm#match
 
I have tried by entering the formula. It works great if I first separat
out the first letter in the names from column A to another column, sa
C, and then use the formula for the new column C and the cell B
containing character t. Somehow, I have not been able to make th
conditional formatting work as suggested. Any suggestions please
Thanks
 
Hi rkumar,

The conditional format solution should work without having
to seperate the letters to a new column. Can you post a
small example of your data? Do not post it as an
attachment though! Or if possible, you can send me a copy
of the file and I'll have a look at it. Here's my addy:
biff_in_pitt<at>comcast<dot>net

Biff
 
Back
Top