Kind regards![]()
Sub colour() ActiveSheet.Unprotect For Each cl In Range(Cells(5, 1), Cells(576, 184)) Select Case cl.Value Case "" Case "E" cl.Interior.ColorIndex = 6 Case "OE" cl.Interior.ColorIndex = 4 Case "ON" cl.Interior.ColorIndex = 33 End Select Next End Sub
Leo
Bookmarks