Conditional format

Navigation: CADSiteTools-Reports > Spreadsheet Editor > Range Explorer > Node settings > Range Selection >

Conditional format

1. Type. Select conditional format type (cell value or expression)

2. Operator. Select logical operator to compare values.

3. Minimum. Type minimum value for the interval.

4. Maximum. Type maximum value for the interval.

Notes:

· The logical operator can be any of the following:

Between. Value must be greater than or equal to the minimum value and less than or equal to the maximum value.

Not between. Value must be less than the minimum value and greater than the maximum value.

Equal. Value must be equal to the value specified.

Not equal. Value must not be equal to the value specified.

Greater than. Value must be greater than the value specified.

Less than. Value must be less than the value specified.

Greater than or equal to. Value must be greater than or equal to the value specified.

Less tan or equal to. Value must be less than or equal to value specified.

· If the condition type is an expression, a valid formula must be entered. If the formula returns TRUE, the font, borders and cell interior settings specified will be applied to the selected cell.