Sort issue
 

I have a group of cells containing names, which I need to sort. That part is
straight forward my problem is that the cells are colored, 5 red over 5
green for a total of 10. Is there any way to sort only the data in the cells
without moving the cell colors?

Sort issue
 

Try using conditional format to format the colours on your worksheet. You
could use the row number to determine the cell colour.

=row()<6


"Patrick C. Simonds" wrote:

I have a group of cells containing names, which I need to sort. That part is
straight forward my problem is that the cells are colored, 5 red over 5
green for a total of 10. Is there any way to sort only the data in the cells
without moving the cell colors?