Hi there,
I have written this VBA that checks column E,F and G and if either of the cells have been coloured with yellow then I need to show the number 1 in column N. If no color if found in any of these columns then the number in column N should be zero.
The macro below is giving me the results across columns J thorugh to column P. Would you please help me to adjust this macro so the results are shown only in column N? Much appreciated
I have written this VBA that checks column E,F and G and if either of the cells have been coloured with yellow then I need to show the number 1 in column N. If no color if found in any of these columns then the number in column N should be zero.
The macro below is giving me the results across columns J thorugh to column P. Would you please help me to adjust this macro so the results are shown only in column N? Much appreciated
VBA Code:
Sub SelectCellsHighlightedInYellow()
Dim c As Range
For Each c In Range("A8:G600")
If c.Interior.ColorIndex = 36 Or c.Offset(0, 1).Interior.ColorIndex = 36 Or c.Offset(0, 2).Interior.ColorIndex = 36 Then
c.Offset(0, 9).Value = 1
Else
c.Offset(0, 9).Value = 0
End If
Next
End Sub