[SOLVED]Conditional Formatting to Highlight Cells

[TerryH79]

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?

[6StringJazzer]

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 don't think the highlighting is that much of a challenge but I don't quite follow the certain this and certain that. I can't see any pattern to how the manufacturer determines the cell to highlight and the color to use.

(I also can't figure out what going on in E3. It's a dropdown box with no content, but there is no data validation on it.)

[TerryH79]

My apologies,

I had it save prior without the data validation ( I chose the wrong file).

On Sheet 2 you will see various lighting manufactures. I have grouped them in blocks of specific colours. Each block represents an agent Which will be listed in coloums (G,I,K,M,O etc..)

I when a manufacture is selected in coloum E. I want to coorisponding cell in the the same row to highlight in a specific cloloum. Ei: the first block on Sheet2 will belong to coloum G, the sencond block will belong to colum I and the third to K and so on and so on.

[6StringJazzer]

Looks like the same file again.

In Sheet2, AtLite is in the blue block but your description said green. Apogee is green but you said blue. That's why I was confused about the colors. Do you just want to match the colors on Sheet2?

Do you mean that the first block on Sheet2 is associated with the first agent, Cooper Lighting? And the second block goes with Rainbow Lighting? That's what I assumed.

I needed to add extra data on Sheet2 to make this happen. Have a look. The colors may not be an exact match but you can see the conditional formatting logic involved.

[TerryH79]

This is EXACTLY what I was looking to do!!

THANK YOU!!!!!!

I've been trying for quite sometime to figure this out!
I really appreciate all your help!!