Here is a macro I'm using. You just need the RGB color code (google for codes).
![]()
Sub ColorCells() 'Change A1:M250 to your needed range For Each cl In Range("A1:M250") Select Case cl.Value 'Yellow 'Add or remove as many elements as you want. Case "dog", "cat", "pig" 'use google to search for RGB color codes cl.Interior.Color = RGB(255, 255, 0) 'Blue Case "horse", "bird", "duck" cl.Interior.Color = RGB(153, 206, 255) End Select Next End Sub
Bookmarks