Sorting cells with formatting

D

Derrick

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.
 
A

Aideen

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
 
A

Aideen

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
 
G

Gord Dibben

Aideen

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

Gord Dibben Excel MVP
 
Top