• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1245
  • Last Modified:

Color Changing Combo Box Excel 2003

In Excel 2003 I would like to create a combo box / list box that a user can choose a response of Yes / No from, and when the response is NO I want the box to be red, and when the answer is yes I want it to be green.  I would like this to be in the column 1 from Row 2 to Row 2- 99.
0
GaDZooKs2004
Asked:
GaDZooKs2004
  • 3
  • 3
1 Solution
 
Rory ArchibaldCommented:
Select A2:A99
Choose Data-Validation from the menu, select 'List' from the Allow box and type:
Yes, No
in the Source box and press OK.
Then select Format-Conditional Formatting from the menu. Choose 'Cell Value Is', 'Equal to' and type No in the box, click the Format button and choose Red from the Pattern tab. Click OK once. Now click Add>> choose the same options but put Yes in the box instead of No, click the Format button and choose green on the pattern tab. Click OK twice to return to Excel.
HTH
Rory
0
 
GaDZooKs2004Author Commented:
Thanks Brother!  You Truly Are A Genius.....Or so I have been told.


FN
0
 
Rory ArchibaldCommented:
Yep - got the T-shirt to prove it! :)
Rory
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
GaDZooKs2004Author Commented:
Well then how do you make it so when you type the letter Y or N that it displays the drop combo answer?

FN
0
 
Rory ArchibaldCommented:
It's *FAR* more trouble than it's worth to implement that, believe me. You would be better off just having Y/N in the validation list choices. Alternatively, once you start filling in the data, Excel's Autofill feature should kick in and achieve what you want anyway.
Regards,
Rory
0
 
GaDZooKs2004Author Commented:
Thanks again!  I can do without the *FAR* more trouble, I really do try to do things by the KISS method.

FN
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now