Sub test()
For r = 4 To Range("c65536").End(xlUp).Row
For c = 3 To 8
If Cells(r, c).Interior.ColorIndex = 3 Then
t = c
Cells(r + 1, 11) = Cells(r + 1, t).Value
Exit For
End If
Next
If c = 9 Then Cells(r + 1, 11) = Cells(r + 1, t)
Next
End Sub
Sub test()
For r = 4 To Range("c65536").End(xlUp).Row
For c = 3 To 8
If Cells(r, c).Interior.ColorIndex = 3 Then
t = c
Cells(r + 1, 11) = Cells(r + 1, t).Value
Exit For
End If
Next
If c = 9 Then Cells(r + 1, 11) = Cells(r + 1, t)
Next
End Sub