On 16 Iul, 17:03, C wrote:
How do I get the complete row to fill A1:J1 if E = Closed?????

A little answer :

Sub ColorGray()

If Range("E1").Value = "Closed" Then
Columns("A:J").Select
With Selection.Interior
.ColorIndex = 15
End With
End If

End Sub

When this cell = Closed ..... ....

Which one ? I put in in cell E1 , make adjustments according
with your needs