I also posted this in the Excel General forum almost a week ago. Not sure if this can be done without VBA, thus the reason I post it here again. http://www.excelforum.com/excel-gene...ll-border.html

Hello everyone,

Whenever I sort some data by alphabetical order, the background colors the cells has are being moved accordingly.
Some cells have borders which aren't moved however. So when the order changes when I want them alphabetical the border doesn't move, meaning another value now has it instead. How can I accomplish this?

Kind regards,

Marco