none
What are the names of these colors? RRS feed

  • General discussion

  • IntelliSense reveals a large variety of colors:

    Sometimes we have the color, but we need a name for it:

    Is there a conversion table somewhere?

    TIA.

    Tuesday, July 29, 2014 10:27 AM

All replies

  • The colour names are not pre-defined, there isn't a lookup table for them. However names do appear when you hover over the colours (in the Ribbon, not the ctrl-F1 dialog you show above).

    Internally there appears to be a small list of basic colour names, not many more than about 20. Hue values are calculated from the RGB values of colours in the top and bottom rows, and matched to the nearest Hue value assigned to respective colour names, then "light" or "dark" included if +/- a given luminosity. Colours in the middle rows are tints (variations in % luminosity) of the top row colours. The bottom row is the same in all colour schemes.

    Your dialog shows the default Office scheme for 2007 & 2010 (2013 is different). If your files only include this scheme, hover over each colour and note the names in the tool tips.

    Tuesday, July 29, 2014 11:45 AM
    Moderator
  • Maybe this will help.

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


    Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.

    Wednesday, July 30, 2014 6:06 PM
  • Using ARGB values you can produce 16777216 colors. 0 to 256 = 256 for an R, G or B value. 256 ^ 3 = 16777216 possible color combinations.

    Then there is the A value (Alpha channel) which relates to the created color in that the pixel representing that color can be fully transparent when that value is set to 0 or fully visible when that value is set to 255.

    List of Named Colors

    500 plus colors

    Web safe colors

    Web smart colors

    INTERNATIONAL COLOR CONSORTIUM


    La vida loca

    Wednesday, July 30, 2014 6:27 PM
  • Assuming the below 56 color palette from Excel Color Palette and Color Index change using VBA in the image below is accurate for the excel colors then I looked up each on and added in the right hand column the name if the RGB values have a name.

    Some have names,  some names are repeated once for some reason which makes me suspicious of the color palette information being accurate.


    La vida loca

    Wednesday, July 30, 2014 7:51 PM
  • Re:  xl2003 colors

    Mr. Mb,
    Thanks for posting the link to the 500 color names.  I have saved that.
    Also, to clarify...
    There are 56 colors available in the Excel 2003 color palette.  Ten of them are duplicates.
    The picture posted below lists them by Color Index number (1 thru 56), which is a Microsoft designation.
    The duplicate colors are noted with an X (20/2 = 10 duplicates)
    All of the colors have names assigned by MS (displayed in the application tooltip).
    '---

    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)







    • Edited by James Cone Tuesday, November 1, 2016 2:30 AM
    Friday, August 1, 2014 1:19 PM
  • Color Palette and the 56 Excel ColorIndex Colors

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


    Ankur Chakravarty Hyderabad

    Friday, August 1, 2014 8:26 PM