VBA-Fill color based on multiple criteria

I am a VBA novice. Using the basic color palette in Excel (note: my business still uses 2003), I want the fill color of a cell to change based on the name of the color input into the cell. For instance, if "red" is typed in A1, the fill color of A1 turns to red. If "yellow" is typed in B1, the fill color of B1 turns to yellow. In addition, other pages in my notebook will reference these cells with a simple equal function and those cells also need to change to the correct fill color.

I have searched the internet for two days and cannot find an answer. Help would be greatly appreciated.

Conditional formatting makes it easy to do what you have described. Just set a rule where if a cell contains the text red, yellow, etc it fills with that corresponding color. A couple of rules may be neccessary but shouldn't take you too long. Then just set the range you want it to associate with.