Hello Everybody,
I am using Microsoft Excel 2003.
I put color in my cells to show contrast with the information in my data list. I used blue and white for my cell colors. When I used sort to put my information in alphabetical order it did not only rearrange the information, it also rearranged the colored cells. My orginal pattern (before using sort) was blue, white, blue, white, blue, white. After I used sort, the pattern was changed to white, white, blue, white, blue, blue.
Is there any way I can use sort to arrange my information only in alphabetical order, using sort, without rearranging the color of the cells?
If anybody knows, please answer and thank you in advance.
Bookmarks