| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
when i sort, how can i get the formatting to sort along with text
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when i sort, how can i get the formatting to sort along with text
What type of formatting are you talking about?
Assuming a list of months in column A......January through December with every third month bold. Sort alphabetically and the bold months remain bold as they move around. Gord Dibben MS Excel MVP On Mon, 11 Sep 2006 06:24:01 -0700, PJ wrote: |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when i sort, how can i get the formatting to sort along with t
I guess it would be the cell formatting as opposed to the text formatting;
i.e. shading and borders. I see that the text formatting does hold when sorting. There are several field types i am sorting; date and time fields and regular text fields. thank you. "Gord Dibben" wrote: What type of formatting are you talking about? Assuming a list of months in column A......January through December with every third month bold. Sort alphabetically and the bold months remain bold as they move around. Gord Dibben MS Excel MVP On Mon, 11 Sep 2006 06:24:01 -0700, PJ wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
| Filtering out text with conditional formatting | Excel Discussion (Misc queries) | |||
| Highlighting text using conditional formatting | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Quick way to sort lists by text color? | Excel Discussion (Misc queries) | |||
Hybrid Mode
