+ Reply to Thread
Results 1 to 2 of 2

Change Shape Color RGB based on Cells Color

  1. #1
    Registered User
    Join Date
    08-14-2014
    Location
    Lisbon
    MS-Off Ver
    2010
    Posts
    8

    Change Shape Color RGB based on Cells Color

    Hi,

    I have already a VBA code that creates a organigram based on a table.
    One of the column is called "Entity" and actually one part of the code is this:

    Code:

    Please Login or Register  to view this content.
    And works, if some rows have "PT" in the Colum "Entity" that shape will be fill with the color "RGB(192, 215, 155)".

    What i would like, is to create a table in a diferent Sheet, for example "sheet2" where i have a Table (database) with 2 columns:
    In cloumn A i would have the Entitys (example: PT, ENG, FR, SP, etc...) and in the column B for each Entity i will fill with a diferent color.

    My goal is substitute the "PT" for column A and the RGB(192,215,155) for the correspondent color in column B.

    Many thanks,

    Goncalo
    Last edited by davesexcel; 03-30-2019 at 05:30 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Change Shape Color RGB based on Cells Color

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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. VBA change shape color based on cell value
    By noelmus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2018, 06:31 PM
  2. change shape color based on a cell value on another sheet
    By aleenkhan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2017, 11:14 AM
  3. [SOLVED] Need to change cell color based off of RGB Color being defined in 3 cells
    By Chris McGlothen in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-01-2017, 02:13 PM
  4. VBA: Change Shape Color based off cell value
    By emmz5d in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2016, 04:35 PM
  5. Shape Color Change Based on Value in different sheet
    By kevinspocket in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2014, 05:50 PM
  6. change fill color of a range of cells based on color of a cell?
    By DarMelNel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2014, 04:48 PM
  7. change color of shape based on value in dropdownlist
    By raketman007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2013, 09:39 AM

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