Selecting Values by Using HighLighting

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.

There are five types of selections which can be made based upon highligting:

1. Select only highlighted cells
2. Select only cells which have NOT been highlighted
3. Select all cells regardless of highlighting or not
4. Select only cells of the specified color (or color index)

All of these commands require that the name of the sheet be provided, along with the highlighting option.

To illustrate, the commands for tests of benford's Law will be shown below corresponding to each of the numbered options above:

1. be sheet=Test hilite=yes title="Benford's Law (Only highlighted cells)"
2. be sheet=Test hilite=no title="Benford's Law (Only highlighted cells)"
3. be sheet=Test hilite=n/a title="Benford's Law (Only highlighted cells)"
4. be sheet=Test hilite="light green" title="Benford's Law (Only highlighted cells)"

Note that as an alternative, the last command could have specified hilite=35 because 35 is the colorindex for light green. See further details on color index.

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