Excel Color Index

Cells within a worksheet can be highlighted with different colors. These colors are then used to identify to the various commands such as ks, po, t5, b5, un, etc. which cells are to be included in the analysis. The color values can be specified either by color or their associated color number.

The default colors

An example of the specification of colors by name (assumes that the worksheet has been highlighted in yellow and light green:

po sheet=Test hilite="light green" title="Percentile Analysis - 2007"

An alternative to typing in "light green" is to specify the actual color index, which is 25 for light green:

po sheet=Test hilite=35 title="Percentile Analysis - 2007"

Main Form