+ Reply to Thread
Results 1 to 2 of 2

change color of shape based on value in dropdownlist

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    brussels
    MS-Off Ver
    Excel 2003
    Posts
    1

    change color of shape based on value in dropdownlist

    hello,

    i'm trying to figure out if it is possible to do this:
    - cell with a dropdownlist of 'red, green 'amber'
    - a shape on another sheets gets the color from the dropdownlist

    so fill color is green of 'green' is seldted from the dropdownlist

    Does anyone has an example worksheet for this?
    thanks!
    W

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,399

    Re: change color of shape based on value in dropdownlist

    do you really need code?

    You can use conditional formatting if you name the cell used for data validation list.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Change Shape Fill Color Based on Cell Value
    By Justair07 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-28-2013, 09:35 AM
  2. Add command button to shape and change shape color on mouseover
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-26-2012, 05:12 PM
  3. trying to change two or more shape's color based on thier location, please advise
    By nimikipod in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-13-2011, 04:01 AM
  4. Can a macro change the color of a shape?
    By ditisFloris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2010, 08:21 AM
  5. Change shape color on mouseover
    By grime in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2007, 02:57 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1