curbster,

Try:


Sub FindS_C_OinAD()
Dim c As Range, LR As Long, a As Long
For Each c In Range("AD2", Range("AD" & Rows.Count).End(xlUp))
  If UCase(c.Value) = "C" Or UCase(c.Value) = "S" Then
    Range(Cells(c.Row, 1), Cells(c.Row, 39)).Font.ColorIndex = 3
    Range("L" & c.Row) = Range("L" & c.Row) * -1
  End If
Next c
LR = Cells(Rows.Count, "AD").End(xlUp).Row
For a = LR To 2 Step -1
  If UCase(Cells(a, "AD").Value) = "O" Then
    Rows(a).EntireRow.Delete
  End If
Next a
End Sub