View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lerner Lerner is offline
external usenet poster
 
Posts: 39
Default Alphabetically list of last names: BOLD, not bold

Actually none of them had work.
A B C

1 NAMES

2 ARIES, JOHN

3 ACTUAL, JANE

4 CONSECUTIVE, MIKE

5 EXCEL, MICROSOFT

6 EVEREST, TRISIA

7 HINGS, PAULA

Basically the thing is get the first one ( last name with A) BOLD and then
alternating with the list (not bold, bold, not bold, bold) regardless of the
missing secuency as in this case it will be ABOLD, Cnot bold, E bold,
H not bold.
I'd rather use conditional formatting than MACROS.
Thanks.