[SOLVED]Conditional Formatting to Highlight Cells

Hi there, I'm fairly new to Excel, I can fumble through most tasks I need to use Excel.
I've been having quite a bit of trouble with this one.

I'm trying to highlight centain cells, by selecting text from a drop down menu created from a list of names on another sheet in the work book.

I Would like to select a manufacture from the drop down menu in coloum E. When a certain manufacture I want it to highlight a certain cell in the same row, in a certain coloum. Ei: if Atlite is selected in E3, I want G3 to highlite green. If Apogee is selected in E3 I want I3 to highlite blue. If Atlite is selected in E4 I want G4 to highlite green etc...

I figured out that I could make this work by using =$E$3="....."
I would have to enter this thousands of times, and the file size would be MASSIVE.

Is there a better way of doing this?