Maintaining alternate row colors when sorting?

[slam]

Is this possible?

I want rows to be alternately colored, but I also have this macro (below) that auto sorts upon entering the worksheet - this can scatter the row colors so they no longer alternate. Any way around this?


Private Sub Worksheet_Activate()
Range("B3:AB18").Sort Key1:=Range("X3"), Order1:=xlDescending, _
Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

 

[Norie]

How are you colouring the rows?

If it's using something based on the row rather than value then the formatting should be maintained after sorting.

 

[VoG]

You could use Conditional Formatting to color the rows http://www.contextures.com/xlCondFormat03.html#Shade