Sort issue

P

Patrick C. Simonds

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?
 
R

ruthki

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

=row()<6
 
Top