RGB color codes

[FP-Basic_Ike]

I do not understand the use of RGB color codes. How can I get different shades of blue and green? In what way should I use those codes from 1-255 to get different shades?

 

[Andrew Poulsom]

Maybe this will make it clear:

http://support.softartisans.com/kbview_1205.aspx

 

[xld]

In Excel 2003 and earlier, it doesn't what colour you chooes, Excel will map it to the nearest colour in the 56 colour colour palette. You can change any of the 56 colours via Tools>Options>Colors, but you only have a usable palette of 56 colours.

 

[Domski]

Do you specifically need to use the RGB colour codes? You maybe would be better to use the standard 56 colour pallete that exists in Excel.

You can get a list of these colours by running this code on a blank worksheet:

Public Sub GetColours()
    Dim x As Integer
    
    Application.ScreenUpdating = False
        For x = 1 To 56
            Cells(x, 1) = x
            Cells(x, 2).Interior.ColorIndex = x
        Next x
    Application.ScreenUpdating = True
End Sub

Dom