[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Color Changing Combo Box Excel 2003

Posted on 2007-03-29
6
Medium Priority
?
1,238 Views
Last Modified: 2012-08-14
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
Comment
Question by:GaDZooKs2004
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 200 total points
ID: 18816368
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
 
LVL 1

Author Comment

by:GaDZooKs2004
ID: 18816683
Thanks Brother!  You Truly Are A Genius.....Or so I have been told.


FN
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 18816954
Yep - got the T-shirt to prove it! :)
Rory
0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
LVL 1

Author Comment

by:GaDZooKs2004
ID: 18817194
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
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 18817554
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
 
LVL 1

Author Comment

by:GaDZooKs2004
ID: 18825083
Thanks again!  I can do without the *FAR* more trouble, I really do try to do things by the KISS method.

FN
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question