More than 3 conditional formatting excel 2003

Hello,

I have the need for more than three conditional formats for rows in a table based on conditions in a specific cell....

PreConditions Condition Data 1 Data 2 Data 3 Data 4
3 left 5 6 2 3
4 right 1 8 2 2
10 top 7 6 10 5
1 bottom 4 9 7 3
9 square 7 9 10 4
9 circle 3 4 2 8
x triangle 4 7 1 5
3 left 9 3 5 10
6 left 10 3 9 4
9 left 4 6 6 4
2 right 5 9 6 3
0 top 10 9 8 0
x bottom 8 4 9 6
8 bottom 2 8 4 1
8 bottom 6 7 1 5
7 square 8 5 9 7
3 square 0 6 4 3
1 circle 9 8 3 9


I am using excel 2003 (yes, I know it's old, but that is what my company is using!) What I need to do is to evaluate the text in column b and then set the color of that entire row to a specific color. For example, if the cell contains "left", I want the row to cell background to turn yellow, if "right", then red, etc. I know that I need to use VBA since there is more than three conditional formats, but don't have the skill to write. I was wondering if someone could give me the correct code that I can then implement in my spreadsheet. Any help would be greatly appreciated.