Dropdown lists - Displaying colour & text format

Hi,

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.
kazmdavAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

[ fanpages ]IT Services ConsultantCommented:
Hi,

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.

BFN,

fp.


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 ]
0
kazmdavAuthor Commented:
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.

Cheers!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kazmdavAuthor Commented:
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.
0
[ fanpages ]IT Services ConsultantCommented:
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.
0
[ fanpages ]IT Services ConsultantCommented:
Yet again, I object.

However, it seems pointless.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.