Keep formatting after a sort is performed....

[wotonka]

I have a worksheet with grouped / similar cells highlighted with unique fill colors and the same groups of cells have a box outlining the perimeter of the groups.

So for example:
Cells D3:D4 are yellow, contain the value "15" and have an outline box drawn around their overall group
Cell D5 is green, contains the value "12" and has an outline box drawn around it
Cells D6:D7 are blue, contain the value "3" and have an outline box drawn around their overall group

If I sort the above cells based on cell contents, the fill colors do seem to move with the sorted cells, but the outline boxes do not. In other words, the outline boxes do not seem to move at all with the "sort".

Short of writing some VBA code to put the outline boxes around the right group of cells after the completed sort, does anyone know of a way to get the outline boxes to move with the sorted cells ??

Finally, some of the cells contain conditional formatting. It seems the conditional formatting stays with the original address of the cells, but this formatting unfortunately does not move with the newly placed cell after the sort has finished. Is there a way to get the formatting to move with the cells that have been sorted?


Thanks in advance for any help you may offer.