How to let the formatting follow data during sorting?

[JimAnAmateur]

Hi,

During sorting in Excel (primarily programmatically I am working with, but
same when manually doing this), I could not find ways of letting the
formatting properties follow the data cells.

E.g., some particular cells are marked with yellow color before sorting.
After sorting (e.g., entire rows), the yellow color are not moved with those
particular cells, so the wrong cells get the yellow color after sorting.

Any suggestions?

 

[Shasur]

Hi

Are you sure that the entire rows are included in the sort

Normally when we 'color' a row, Excel colors from Column A to IV. However,
when coding we use the range (usedrange or some specific range) and Excel
Ignores the rest of columns during sorting

Cheers
Shasur

 

[JimAnAmateur]

Thanks!

My bad, it was Range and not entire rows I had in my macro.

 

[Jim Cone]

Sounds like you have conditional formatting (CF) applied to some of the cells.
Conditional formatting does not sort with the cells.
Also borders do not sort with cells.
--
Jim Cone
Portland, Oregon USA



"JimAnAmateur"
wrote in message
Hi,
During sorting in Excel (primarily programmatically I am working with, but
same when manually doing this), I could not find ways of letting the
formatting properties follow the data cells.

E.g., some particular cells are marked with yellow color before sorting.
After sorting (e.g., entire rows), the yellow color are not moved with those
particular cells, so the wrong cells get the yellow color after sorting.
Any suggestions?