i have a worksheet with data in column A, every row is either grey or
white shading. i always want to keep the shading alterante grey/white

a1: 7 (white shading)
a2: 4 (grey shading)
a3: 3 (white shading)
a4: 5 (grey shading)
a5: 1 (white shading)
a6: 2 (grey shading)

when i sort assending it mucks up the shading becuase it moves the data
as well as the shaded cell.
is there any way of keeping the cells locked and just sort the data???


--
on-a-mission
------------------------------------------------------------------------
on-a-mission's Profile: http://www.excelforum.com/member.php...o&userid=31630
View this thread: http://www.excelforum.com/showthread...hreadid=513248