Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting
When I have the worksheet filled with different colors to distinguish certain
things it will not sort alphabetically. Can anyone help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting
Hi CoCoa,
Do you mean the values are not sorting alphabetically or the colors are not moving when the values are sorted? How did you color the cells? Did you just change their fill color or did you use conditional formatting? If you just changed their fill color then the colors will not be affected by the sort. If you used conditional formatting the colors will change according to the result of the sort. Ken Johnson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting
Hi CoCoa,
Oops! I honestly thought that fill color would not be affected by sorting. After trying it out I have to ever so humbly retract that statement. Sorry about that. Ken Johnson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting
I don't understand it either because I need to figure this out for my
business. I think that I might contact microsoft office for a solution. I still have one free time to contact them. "Ken Johnson" wrote: Hi CoCoa, Oops! I honestly thought that fill color would not be affected by sorting. After trying it out I have to ever so humbly retract that statement. Sorry about that. Ken Johnson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting
Hi CoCoa,
So you want the fill color to be unaffected by the sort? I'd like to know what you find out? Ken Johnson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting
Hi CoCoa,
If I'm correct in assuming that you want the cells' fill colors not to be affected by the sorting then one way is to use conditional formatting. Say you want A1 to have a yellow fill, then go: FormatConditional Formatting... select "Formula Is" in left box type "=OR(NOT(ISBLANK($A$1)), ISBLANK($A$1))" in the right box (without the speech marks) Click on the Format... buttonselect yellow fill then click OK. This over-rides the normal fill color that moves when sorting. The Formula used is true regardless of what type of data is in A1. Tedious aye. Ken Johnson |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting
Hi CoCoa,
Forget about the unnecessary formula, use "=1=1" instead. This too is always TRUE and works just as well as "=OR(NOT(ISBLANK($A$1)), ISBLANK($A$1))". The latter formula is very good for toning up your finger muscles ;-) Ken Johnson |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting
Hi CoCoa,
This should earn me the "Pillock of the Year" award! All you need to type in the Formula Is box is =1 Also, I wouldn't mind betting this is not really what you are trying to do anyway! Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
Adding a KeyID column for sorting | New Users to Excel |