ExcelBanter - when i sort, how can i get the formatting to sort along with text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - when i sort, how can i get the formatting to sort along with text (https://www.excelbanter.com/excel-worksheet-functions/109381-when-i-sort-how-can-i-get-formatting-sort-along-text.html)

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:

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: