How to let the formatting follow data during sorting?
 

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?

How to let the formatting follow data during sorting?
 

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?