Results 1 to 7 of 7

Change shape fill color depending on cell value

Threaded View

  1. #1
    Registered User
    Join Date
    01-22-2010
    Location
    Norway
    MS-Off Ver
    Excel 2007
    Posts
    33

    Smile Change shape fill color depending on cell value

    Hi guys,

    (newbie vba)
    I've been searching the web for the following issue (I just cannot seem to get it to work):

    I've got two shapes in which I want the color to change depending on a drop down list Open/closed.

    If valve_1 has status "Open" then that corresponding valve is to be filled with green.
    If it is "Closed" it is to be red.
    The same for Valve 2.

    I have uploaded what I've got so far on the basis of an example I have found online, but it just does not work.

    Any help much appreciated.
    Attached Files Attached Files

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. Change cell fill when changed different color depending on the day
    By rev0jace in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2012, 11:06 AM
  4. Fill Cell with Color from Shape's color code
    By excelnewbie80 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-02-2012, 05:34 PM
  5. Replies: 3
    Last Post: 07-08-2010, 06:48 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