Sorting names from a list

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
 
B

Biff

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
 
B

Biff

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

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

Biff
 
D

David McRitchie

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
 
Top