Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)

Figure 30-3 shows a workbook that I created that deals with colors. If you're at all confused about how the RGB color model works, spending some time with this color demo workbook will probably make it all very clear.

Figure 30-3: This workbook demonstrates how red, green, and blue colors combine.

This workbook contains three vertical scrollbars, each of which controls the background color of a range. Use these scrollbars to specify the red, green, and blue component for a color to values between 0 and 255. Moving the scrollbars changes several areas of the worksheet:

• The cells above the scrollbars display the color components in hexadecimal (00 “FF) and in decimal (0 “255).Hexadecimal RGB color values are often used in specifying colors for HTML documents.

• The ranges next to each scrollbar change intensity, corresponding to the scrollbar's position (that is, the value of the color component).

• A range below the scrollbars depicts the combined color, determined by the RGB values you specify.

• A cell displays the decimal color value.

• Another range depicts the color's approximate appearance when it is converted to grayscale.

• A range of cells shows the corresponding HSL color values.