Thanks for the response, and it would be a good one, but unfortunately the
formatting across the row is not constant from cell to cell.

"Marcus Langell" wrote:

A solution would be to create a "format code" column and make the formatting
conditional on the contents of that column. Then if that column is sorted
with the rest of the table, the formatting will follow. (Unfortunately, you
can only have three format sets when using conditional formatting.)

/Marcus


"Paul" wrote:

I want to be able to sort AND have the cell format stick with the data being
moved. The formats are color, and border.

Can it be done and how?