Sorting cells with formatting

[Guest]

I've a spreadsheet where I formatted certain cells with fills and borders.

When I sort the cells, the formatting stays and did not move with the cells.

Is it possible to sort the cells such that the format stays with the
specific cells?

Thanks.

 

[Frank Kabel]

Hi
no this is not possible

 

[Guest]

Frank. I have sorted many excel spreadsheet where the formatting (ex.
colored cells) stays with that specific cell. So this is absolutely
possible. However, for the first time, today I encountered the same problem
that Derrick did and can't seem to figure it out.

Aideen

 

[Guest]

Derrick,

I have done this kind of sorting many times and up until today the
formatting (ex. colored cells) stayed with the cell. If you figure out how
to solve this, please let me know.

Aideen

 

[David McRitchie]

Depends on what formatting,
the interior color will go along with the cell,
the borders will not. Example:

Sorting, Some notes on sorting in Excel
http://www.mvps.org/dmcritchie/excel/sorting.htm#borders

 

[Gord Dibben]

Aideen

If the cells are colored due to Conditional Formatting, the color will stay
with the sorted cell.

Gord Dibben Excel MVP