I have been trying to use a macro to change the colors of a cell.. the first
change from default to pink is ok but then it will not change to another
color.

If t6 = yes Then
Range("t7:w7").Select
Selection.Interior.ColorIndex = 7
ElseIf u6 = no Then
Range("t7:w7").Select
Selection.Interior.ColorIndex = 2
ElseIf w6 = yes Then
Range("t7:w7").Select
Selection.Interior.ColorIndex = 4
Else:
Range("t7:w7").Select
Selection.Interior.ColorIndex = 2
End If
End Sub

Any ideas would be appreciated.... thanks for the help in the past