With 15 different 'types' to choose from, I think he's going to need a
combination of solutions - unless he has Excel 2007, earlier limits on
conditional formatting aren't going to allow him to use 15 colors?

"Bob Phillips" wrote:

Conditional formatting. See http://www.contextures.com/xlDataVal01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
oups.com...
Hi,

I have a problem. I am making a spreadsheet for a computer company
for my A level ICT and in this spreadsheet I have a "stock" worksheet.
In this work sheet there is Stock name, compant field,type, quanty and
price field. When chosing which type the user wants to buy i want the
whole row to turn a differnt colour depending on what type they chose.
I have put a validation rule on the type field so that a list of 15
types of stock appear. How do i make it so the whole row changes
colour when they chose a type?

Thanks.

Trudy x