+ Reply to Thread
Results 1 to 2 of 2

Fill Colorfrom Cell Value

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Calfiornia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Fill Colorfrom Cell Value

    I have a spreadsheet that has the hex color code value in a column and then the corresponding RGB values in the next 3 columns. Is there a way to make the fill color of a cell automatically use either the Hex or RGB values for the fill color of a cell (like the next cell in the row)?

    TIA for any assistance.

    MotoMania (aka Mick)

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Fill Colorfrom Cell Value

    You really need to explain in more detail what you are trying to achieve, as well as post a sample workbook to illustrate your requirements.

    Can't say that this code is what you need, but you can try it and see if does.
    It goes into a standard module.

    The code only checks to see that you are on a row other than row1 and assumes you have RBG values in the above row in columns B:D - it then uses these RGB values to color the activecell.

    Please Login or Register  to view this content.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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