Sorting and having cell formats stick with contents

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?

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?

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?

When I sort in Excel '97, 2000 or 2003 the cell colour stays with the item (ie, travels to the new location)

The Border is more difficult as the border on a border'd cell also applies to four adjacent cells.

As you only need to specify the Border perhaps Marcus' idea of Conditional format could be the go, but I thought the 'condition' had to relate to the current cell rather than a helper cell (the helper condition would be most useful here)

Originally Posted by Paul

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?