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?