Auto Sort Overrides Color Sort

Originally Posted by xladept

Just add a call to the color sort after the auto sort:

Private Sub Worksheet_Change(ByVal Target As Range)

On Error Resume Next
If Not Intersect(Target, Range("A:A")) Is Nothing Then
Range("A1").Sort Key1:=Range("A2"), _
Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom

End If
Call Colorsort
End Sub

This didn't work for me