Sorting & retaining cell format

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

hi

i want to sort a range of A2:D20 by the headers in row 1.
however some of the cells in column B have specific
formats with different cell colours and a border that
diagonally cross the cells in red, to make it looked
crossed out.

when i set up the sorts they work OK but the border
formatting stays with the original cell location rather
than moving with the correct text.

does anyone have any ideas?

Nick
 
Hi Nick
AFAIK the only workaround would be using conditional format based on
your cell values. Fixed border formats will not be sorted.
Frank
 
Frank said:
Hi Nick
AFAIK the only workaround would be using conditional format based on
your cell values. Fixed border formats will not be sorted.
Frank
Click to expand...
Another way might be to use VBA to copy the range, sort, then paste back
over the range as "formats only"
 
Why not actually use strike out if that is what you are
indicating. Format, cells, font, [x] strikethrough
or else use a pattern with thin diagonal lines
Format, Cells, patterns, ...

 
Back
Top