In VBA code, I need to have the background color of the cells in Column H
change depending on Text in the Cell. I can not use conditional formating
because I have to many codes and colorsr.

Code
A-1 background color Green
A-2 background color Green
G-1 background color Yellow
G-2 background color Yellow
G-3 background color Orange
CA-1 background color Blue
GA-1 background color Black
GA-2 background color Gray