Hi there.
I've written this simple code.
What I want it to do is to thange background of the cell in the 6th (J) collumn if all the cells in the 7:21 collumns values is ether "Yes" or "No".
I actually want to use a custom color, but before ill focus on that, ill need the code to work as it is.
Ive reached my limits here, so any help will be much appreciated
Thanks
I've written this simple code.
PHP:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
For i = 6 To 20
If ((Cells(i, "7:21").Value = "Yes" Or "No")) Then
Cells(i, 6) = Selection.FormatConditions(1).Interior.Color = 3
End If
Next
End Sub
What I want it to do is to thange background of the cell in the 6th (J) collumn if all the cells in the 7:21 collumns values is ether "Yes" or "No".
I actually want to use a custom color, but before ill focus on that, ill need the code to work as it is.
Ive reached my limits here, so any help will be much appreciated
Thanks