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