Changing Excel cell color based on other field

[DonS100]

I'm going to push some raw data into a excel worksheet from access. I then want to have another worksheet that is better formatted for the user but based on the first tab. Lets say the the raw data worksheet has 200 rows with 2 column each. The first column in is for the product description and the second has a color value in it.
Example:
Column1/Column2
Row1=ProductA/Blue
Row2=ProductB/Red

The second worksheet would have a cell with the text ProductA in it, the cell would be blue. The cell below would have the text ProductB and cell color would be red.

How can you do this?

Thanks

Don

 

[Griffyn]

Click Format, Conditional Formatting.

Pop in some formulas akin to =IF(A1="ProductA",True,False) and then modify the formatting to give you the desired effect.

 

[GlennUK]

How many colours are going to be specified in column 2? If it's more than 3 then conditional formatting won't do it.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.