Hi good morning, hope you can help. I have the code below where if OOH is in a cell I want the whole row to change colour, but the code below is not working, hope you can help?
Private Sub Highlight()
Dim col As Range
Dim value(0) As Integer
Worksheets("Sheet1").Activate
Set col =...