set your conditional format to the formula option.your first format when the
cell link for your drop down box= 1 is one colour,2=second colour,3=third
colour
--
paul
remove nospam for email addy!



"MGC" wrote:

I have created a drop down menu with 3 options
Contact
Enquiry
Order
I want the colour of the text in the row next to the drop down menu to
change for each option when it is selected in the menu. Help!