none
Number of the color RRS feed

  • Question

  • Hi,
    How do we know the number should be, to the color below, to one Excel range?
            With range.Interior
                .Pattern = Excel.Constants.xlSolid
                .PatternColorIndex = Excel.Constants.xlAutomatic
                .Color = color
    			...



    Many Thanks & Best Regards, Hua Min

    Friday, November 27, 2015 1:45 AM

Answers

  • Hi HuaMin Chen

    You must use RGB ():

    Example :

    .Color = RGB(127,187,199)

    see http://www.proftnj.com/RGB3.htm for the colors.


    • Edited by Malick F Friday, November 27, 2015 1:55 AM
    • Proposed as answer by Malick F Friday, November 27, 2015 2:01 AM
    • Unproposed as answer by Malick F Friday, November 27, 2015 2:04 AM
    • Marked as answer by Jackson_1990 Friday, November 27, 2015 2:11 AM
    Friday, November 27, 2015 1:55 AM