Put this code in the sheet module for that sheet

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Column = 1 Then
' code to add a DataValidation list to column C,
' or code to change the DataValidation list in column C
End If
Application.EnableEvents = True
End Sub

Record and modify a macro to add or modify a datavalidation
and add this code to the above.

Remember to have lists created for color variations.
Or you can build extensive code to create those lists through code.

If you haven't worked with DataValidation - you'll find it under the Data
menu.

Write back if you need more help.

--
steveB

Remove "AYN" from email to respond
"H" wrote in message
...
Column A- Is an Item number that you enter manually
Column B - has an H lookup formula that refers to the number entered in
column A
(Column A is an item number and when entered in Column B the items
description comes up)
I would like column C to have a drop down menu that only has the color
choices that are available for that item.

I'm stuck on column C. Can you do an HLOOKUP formula refering to another
cell that contains an HLOOKUP formula?

Any help would be appreciated.
Thank you
--
-H