Syntax:

ChangeAlertTo, RelativeCell, pageRef, rowIndex, boolRowValueFixed, columnIndex, boolColumnValueFixed, threshold, boolThresholdAsPercent, cssPrefix, tildeDelimitedColumnIndexes

Parameters:

pageRef – the page to be used to determine alert level { page caption text, Current, First, Last, Previous, Next, page index number}

rowIndex – row index or offset to compare

boolRowValueFixed  - whether the row index is fixed (true) or relative (false)

columnIndex – column index or offset to compare

boolColumnValueFixed whether the column index is fixed (true) or relative (false)

threshold –value of the threshold for alerts

boolThresholdAsPercent – whether to treat the threshold as a percentage value (true) or not (false)

cssPrefix – use this prefix for CSS element id for the alerting (followed by Alert0, Alert1, etc)

tildeDelimitedColumnIndexes – tilde-delimited list of column-indexes to be changed, or -1 for all

Examples:

ChangeAlertTo,RelativeCell,-1,0,false,-1,false,15,true,blue,-1

In this example, alerts are based on the current page, same row, previous column (one to the left), and use the ‘blueAlert#’ alerts style with a treshold of 15 percent.

ChangeAlertTo,RelativeCell,-1,0,false,-1,false,15,true,blue,4~5

Same as above, but apply the alerts only to column indexes 4 and 5.

Comments:

Uses CSS elements containing ‘Alert#’ for each alert value (#) in the style sheet file.