Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    I've created a small drop-down list for data validation, which works great. I would like to add either cell shading or text color to the drop-down display. Is there a way to do this?

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    No there isn't, I'm afraid. You can do it with a combobox from the Control Toolbox but you would need one per cell, or code to relocate it when the selection changed. I'm also not a fan of ActiveX controls on worksheets, personally.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Thanks, Rory.

    I figured that it could only be done through code. Writing VBA code is not something that I can do easily (prefer not at all).

    I just thought of using Conditional formatting on the cell where the drop-down list is selected. Would that work to shade the cell once one of the drop-down items is selected?

  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
    Conditional formatting will change the cells display but will have no effect on the dropdown validation list

    Steve

  5. #5
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    I know that the drop-down list will still be black & white, but at least the cells where the selection was made will be shaded. I think we got it!

    Thanks.

Posting Permissions

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