sorting by name
 

I have a spreadsheet that has many conditional formats and blacked-out cells
(indicating that no input is required for that person in that field). It is
currently aplphabetized according to rank, but i need to alphabetize by name,
but i cant get it to carry all the conditional formats.