Dropdown lists - Displaying colour & text format

Posted on 2013-10-08
Medium Priority
Last Modified: 2013-10-19

Excel 2003 or 2010 - Data Validation of (dropdown) List re text with a background colour & font size.  

When an item is selected from the list, is there any way to:
(1) bring across the colour?
(2) display dropdown list (when selecting) as a larger font size?

I just realised that re (1) I could probably put conditional formatting on the target cells, which would be based upon the populated cell from the selection. Correct?  I would prefer it just to come across with the selection, if possible & without VBA code?

Per (2)  I know the user could zoom out the screen so they could actually see the drop down list content, but that is very inconvenient.

Thank you.
Question by:kazmdav
  • 3
  • 2
LVL 35

Assisted Solution

by:[ fanpages ]
[ fanpages ] earned 2000 total points
ID: 39558100

I am not sure if I understand your requirements.  Please correct me as necessary:

Do you mean you have applied Data Validation to a worksheet cell & the source of the Validation list is a range of cells elsewhere on the same worksheet where some of the cells within this range have different font attributes?

Also, I think that when you make a selection in the drop-down Data Validation combo-box, you would like the selected item to then "inherit" the font attributes from the same item within the Validation list range?

If so then, no, sorry, this is not possible without VBA code.



PS. For background reading, Debra Dalgleish has some information on her site about Data Validation (& variants for implementing drop-down lists):

[ http://blog.contextures.com/archives/2010/02/03/3-types-of-excel-drop-down-lists-compared/ ]

[ http://www.contextures.com/xlDataVal08.html ]

For particular reference to your point #2 above.

"Make the Dropdown List Appear Larger"
[ http://www.contextures.com/xlDataVal08.html#Larger ]

Accepted Solution

kazmdav earned 0 total points
ID: 39564406
Hi Fanpages,

Thanks for your response & for the links. So, the answer is no to both. That clears it up for me.

For the sake of this database:  As for the target cell colour, I have used conditional formatting with one rule per list item (excel 2010). Hence, the conditional formatting occurs once the item is selected from the list . Works a treat.


Author Comment

ID: 39569159
I've requested that this question be closed as follows:

Accepted answer: 0 points for kazmdav's comment #a39564406

for the following reason:

Answered my questions appropriately.
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39569160
For the sake of this database:  As for the target cell colour, I have used conditional formatting with one rule per list item (excel 2010). Hence, the conditional formatting occurs once the item is selected from the list . Works a treat.

That's good.

However, for the "sake of this database", the answer to your question is the comment with ID: 39558100 above.

[Object] button clicked.
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39582505
Yet again, I object.

However, it seems pointless.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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

If Skype for Business came with your office 2016 or office 365 installation, you may find that it's almost impossible to either disable or remove it. The application will often launch with each start of Windows, even when explicitly configured not t…
Are you looking to start a business? Do you own and operate a small company? If so, here are some courses you need to take before you hire a full-time IT staff.
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…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

622 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