View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PJ PJ is offline
external usenet poster
 
Posts: 112
Default 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: