VB Code To Replace Conditional Formatting

[JimmiOO]

I have a workbook that requires a VB code to help me out with Conditional Formatting. I use Office 2003 which is restricted to 3 conditions, I know there is an add in I can use that would help me do this but other people may use this that wont have the add in. I have decided to use VB if possible to get this done.

I have a range of cells from B22 – T22 in these cells I will be putting codes, when these codes are put into the cells I would like the cells to shade a different colour depending on what code I use. Here is an example of what I mean.

P = blue

S = red

HL = green

ML = magenta

FL = orange

I may have a couple of more codes I will add at a latter time. Is it possible for VB code to do this?