I really need some with a color update for multiple ranges.
I want 2 separate columns to receive their value as well as color updated, but (probably due to the Range("M2").Select ) It only updated 1 of the 2 columns with the color.
It is updating the values just fine for both columns, but it’s only updating the color for column M and not for column O.

Can you help? 


    Range("M2").Select
    For i = 2 To X
        If Range("M" & i).Value = "No" Then
            If Range("S" & i).Value = "Shipped" Then
                If Range("D" & i).Value <> "RMA" Then
                    If Range("AW" & i).Value = "1" Then
                        Range("M" & i).Value = "Yes"
                        Range("O" & i).Value = "Rescheduled"
                            With Selection.Interior
                                .Pattern = xlSolid
                                .PatternColorIndex = xlAutomatic
                                .Color = 65535
                                .TintAndShade = 0
                                .PatternTintAndShade = 0
                            End With
                    End If
                End If
            End If
        End If
    ActiveCell.Offset(1, 0).Select
    Next i