+ Reply to Thread
Results 1 to 11 of 11

Find a color code's numeric value

  1. #1
    Registered User
    Join Date
    01-07-2009
    Location
    Summit, New Jersey
    MS-Off Ver
    Office 365
    Posts
    23

    Find a color code's numeric value

    I saw somewhere on the net a neat trick to determine the numeric color code using a leading question mark. Of course I've forgotten the routine. Any help?

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

    Re: Find a color code's numeric value

    .
    .
    One of many good resources.

    http://dmcritchie.mvps.org/excel/colors.htm

    Here's two macros to assist as well:

    Please Login or Register  to view this content.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Find a color code's numeric value

    Isn't the easiest way to select the cell in question, click Format Cells, Fill Tab, More Colours, Custom and read the RGB colour numbers?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Find a color code's numeric value

    Isn't the easiest way to select the cell in question, click Format Cells, Fill Tab, More Colours, Custom and read the RGB colour numbers?

  5. #5
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Find a color code's numeric value

    I like to use:
    Please Login or Register  to view this content.
    Lewis

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

    Re: Find a color code's numeric value

    Isn't the easiest way to select the cell in question, click Format Cells, Fill Tab, More Colours, Custom and read the RGB colour numbers?
    Waaay to easy ! Let's use VBA !!!


  7. #7
    Forum Contributor
    Join Date
    12-18-2016
    Location
    London
    MS-Off Ver
    Microsoft 2013
    Posts
    145

    Re: Find a color code's numeric value

    Select the cell that is formatted with the color you want to check.
    Display the Home tab of the ribbon.
    Click the down-arrow at the right side of the Fill Color tool, in the Font group. Excel displays a small palette of colors and some other options.
    Choose More Colors. Excel displays the Colors dialog box.
    Make sure the Custom tab is displayed
    At the bottom of the dialog box you can see the individual values for the red, green, and blue components of the color in the cell.
    Click OK when done.

  8. #8
    Registered User
    Join Date
    01-07-2009
    Location
    Summit, New Jersey
    MS-Off Ver
    Office 365
    Posts
    23

    Re: Find a color code's numeric value

    Thank you all for your replies. But somewhere on the web I found a routine with a leading question mark that returned the rather unwieldy long number that represents shades of color in Excel. I don't remember whether it was in VBA or on the worksheet. It was pretty cool; but I haven't been able to find it again. Should've recorded it somewhere.

  9. #9
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Find a color code's numeric value

    Please Login or Register  to view this content.

  10. #10
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Find a color code's numeric value

    LJM's suggestion works in the Immediate window, where the question mark is a shortcut for Debug.Print.
    Entia non sunt multiplicanda sine necessitate

  11. #11
    Registered User
    Join Date
    01-07-2009
    Location
    Summit, New Jersey
    MS-Off Ver
    Office 365
    Posts
    23

    Re: Find a color code's numeric value

    That's it. Thanks LJMetzger.

+ 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 code for find value in another sheet, if yes then color it
    By theprincesunil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2016, 09:56 AM
  2. [SOLVED] VBA code for assigning a numeric code to text; then numeric code populates table
    By cteaster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2014, 08:01 PM
  3. [SOLVED] Help find MAX value in one column when numeric & alph-numeric values are present
    By KevinAB in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-01-2013, 11:29 AM
  4. Find Numeric Criterion in Column & Return the Numeric Value from Row above
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-27-2006, 09:55 AM
  5. [SOLVED] Is there a way to color the cells based on the numeric value?
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  6. Is there a way to color the cells based on the numeric value?
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  7. [SOLVED] Is there a way to color the cells based on the numeric value?
    By ajyourpal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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