| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
| Excel Macro- sort issue in Excel2003 | Excel Worksheet Functions | |||
| Sort/Filter issue | Excel Worksheet Functions | |||
| Header Rows and Sort Issue | Excel Discussion (Misc queries) | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Linear Mode
