I have a workbook that consists of monthly calenders that uses single text
characters in cells that I want to automatically convert to a specific colour
when entered in a range in each worksheet. I am familiar with conditional
formatting but have more than three different formats. I need some basic vba
code to colour the cells that match the following entire cell contents:

Dog Purple
Cat Blue
M Red
O Yellow
V Green