+ Reply to Thread
Results 1 to 10 of 10

Display colors next to list of hex color codes

  1. #1
    Registered User
    Join Date
    10-16-2014
    Location
    Sunrise, Fl
    MS-Off Ver
    365
    Posts
    41

    Display colors next to list of hex color codes

    color table.jpg
    Need formula or macro to read hex color (RGB) and fill cell with background color.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Display colors next to list of hex color codes

    The formula for that cell would be

    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Display colors next to list of hex color codes

    Quote Originally Posted by Keebellah View Post
    The formula for that cell would be

    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    Those must be UDF's because as far as I know, they are not regular excel functions
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Display colors next to list of hex color codes

    Yes, I should have mentioned that Sorry

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Display colors next to list of hex color codes

    Quote Originally Posted by Keebellah View Post
    Yes, I should have mentioned that Sorry
    Then you should alos provide those UDF's, dont you think?
    lol

  6. #6
    Registered User
    Join Date
    10-16-2014
    Location
    Sunrise, Fl
    MS-Off Ver
    365
    Posts
    41

    Re: Display colors next to list of hex color codes

    Ok, what's a UDF?

  7. #7
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Display colors next to list of hex color codes

    Please Login or Register  to view this content.

    What is a UDF ?

    http://www.myonlinetraininghub.com/c...ction-in-excel
    Attached Files Attached Files
    Last edited by Logit; 03-08-2017 at 10:06 PM.

  8. #8
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Display colors next to list of hex color codes

    Here is an update to the previously attached file :

    Please Login or Register  to view this content.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    10-16-2014
    Location
    Sunrise, Fl
    MS-Off Ver
    365
    Posts
    41

    Re: Display colors next to list of hex color codes

    (UDF = User Defined Function.)

    Thank you very much for the info. I'm not up to speed on programming Visual Basic, though I have done a few short macros.
    Last edited by tcebob; 03-08-2017 at 10:36 PM.

  10. #10
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Display colors next to list of hex color codes

    Let me know if I can assist.

+ 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. assign colors to graphs using color codes in a table
    By flummel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-13-2016, 09:49 AM
  2. Replies: 7
    Last Post: 08-22-2015, 03:51 PM
  3. Replies: 1
    Last Post: 08-22-2015, 12:36 PM
  4. [SOLVED] I need to change the codes and let it reverses the colors back.
    By akinkaraman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2015, 02:39 PM
  5. Filter Zip Codes from a list codes
    By jaugent27 in forum Excel General
    Replies: 3
    Last Post: 06-11-2013, 02:01 PM
  6. Replies: 1
    Last Post: 11-19-2012, 12:04 PM
  7. ComboBox with a list of Metal Colors which changes price when colors are selected.
    By 1976dan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2012, 04:48 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