VBA Conditional Format Cells based on multiple condition

HI,
I am trying to add conditional formatting to a sheet in the workbook through a macro. I have multiple conditions in columns H & K & P; if column 'F' has certain value then color of row changes based on range. Then I want that row to change if the value in column 'H' is either "Approved, Resubmit, Rejected", if 'Rejected' the row would change to different color (red).

Below is the code I have so far, don't relly know how to add additional condition through Macro. I am able to do this within the sheet with multiple condition but, I am having issues with it when I combine data from other sheets. So, need to go Macro route.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("A2:p100")) Is Nothing Then Exit Sub
    Select Case Cells(Target.Row, "F").Value
        Case "Team1"
            Range(Cells(Target.Row, "A"), Cells(Target.Row, "P")).Interior.ColorIndex = 44
        Case ""
            Range(Cells(Target.Row, "A"), Cells(Target.Row, "P")).Interior.ColorIndex = xlNone
        Case Else
            Range(Cells(Target.Row, "A"), Cells(Target.Row, "P")).Interior.ColorIndex = 6
    End Select
End Sub

Thanks.