vendredi 20 septembre 2019

How to color row if two cells on a row both equal complete

trying to, if Range("G2").value & Range("H2").value = "Complete" Then do this.

   If (Range("G2").Value & Range("h2").Value) = "Complete" Then
    Range("a2:j2").Interior.ColorIndex = 6
else
    End If

Aucun commentaire:

Enregistrer un commentaire