Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I thought it would be cool to sort my alphabetical list of names and then
have excel distinguish the a's from the b's from the c's, etc. Is there a way to use the MOD function to tell excel to highlight the a's c's d's, etc. one color and the b's d's e's, etc. another color all the way through the alphabet? If this is impossible, then is there a way to insert a break bar or something between the lists of names at each new last name beginning letter? My list is extensive and I audit by name (alphabetically) - To show the break points between the names would be very helpful. Thanks Y'all |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referencing to cells in a sorted list | Excel Discussion (Misc queries) | |||
Sorted list | Excel Discussion (Misc queries) | |||
how to count records in a sorted list | Excel Worksheet Functions | |||
Need sorted validation list | Excel Worksheet Functions | |||
alphabetical list | New Users to Excel |