I have color pattern on a worksheet and I want the color to stay there permanently.
Every 5 rows I has a color background assigned to it.
I enter about 10 random names.
I, then, want the names to be put in alphabetical order.
I click vAZ to get the names in alphabetical order, but now, the colors are scattered.
I want the colors to just stay where they were in the beginning (blank the first 5 rows, gray the second 5 rows).
Is this possible?
Every 5 rows I has a color background assigned to it.
I enter about 10 random names.
I, then, want the names to be put in alphabetical order.
I click vAZ to get the names in alphabetical order, but now, the colors are scattered.
I want the colors to just stay where they were in the beginning (blank the first 5 rows, gray the second 5 rows).
Is this possible?
Last edited: