Sorting and having cell formats stick with contents

P

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?
 
M

Marcus Langell

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
 
P

Paul

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

Bryan Hessey

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

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

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