Results 1 to 10 of 10
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Format List in Data Validation (Excell 2002)

    Hi

    Is there any way to format text so it will appear formatted in in the drop down list in a data validation cell. I have formatted the list but obviously that does not work.

    Many thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Format List in Data Validation (Excell 2002)

    Not in a validation list.
    Also not in combobox from FORMS toolbar
    You can format if you use a combobox from the CONTROLS TOOLBOX

    Steve

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Format List in Data Validation (Excell 2002)

    You could use the appearance tab of the display dialog in the control panel to change the colour of the message font. This changes the colour of the font in the drop down, and the colour of ALL other message font on your system. So it depends how important the formatting is for the validation drop down! <img src=/S/smile.gif border=0 alt=smile width=15 height=15> (No go for me though!)
    Regards,
    Rudi

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Format List in Data Validation (Excell 2002)

    I didn't even consider this an option, though you are correct, it should be mentioned to provide the full array of ways to do something.

    Like you, I also would not change the control panel settings just to change formatting in excel.

    Steve

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Format List in Data Validation (Excell 2002)

    Hi Steve / Rudi

    Thanks for your reply's I need to think about the necessity of this.

    But thanks anyway

    Braddy
    If you are a fool at forty, you will always be a fool

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Format List in Data Validation (Excell 2002)

    Hi Steve

    I thought I might try the combo box route, but when I go to format the control I don't have a control tab on the format control settings.

    Braddy
    If you are a fool at forty, you will always be a fool

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Format List in Data Validation (Excell 2002)

    right-click on it and choose properties.

    There is a linkedcell, listfillrange, and many,many others to modify the background, fonts, etc

    Steve

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Format List in Data Validation (Excell 2002)

    Right-click the combo box and select Properties from the popup menu instead of Format Control.

  9. #9
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Format List in Data Validation (Excell 2002)

    Hi

    Thanks to all for your replies. I cannot test until tomorrow will let you know how I get on.

    Braddy
    If you are a fool at forty, you will always be a fool

  10. #10
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Format List in Data Validation (Excell 2002)

    Hi Steve

    I managed the combox box with your instructions.

    Thanks to all who replied.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •