Experimenting with Colors


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.

image from book
Figure 30-3: This workbook demonstrates how red, green, and blue colors combine.
CD-ROM  

This workbook, named image from book  RGB color demo.xlsm , is available on the companion CD-ROM.

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.




Excel 2007 Power Programming with VBA
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
ISBN: 0470044012
EAN: 2147483647
Year: 2007
Pages: 319

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net