Conditional formatting involves specifying criteria for applying formatting based on a cell value. A common use in a spreadsheet-based DSS would be highlighting specific ranges of values in various colors.

For example, when a result cell from a model falls in a desirable range it is green, in another range yellow and finally red in a third range of values.

To use this feature click on Format on the menu bar and then Conditional Formatting.

Use conditional formatting, but use it sparingly!

appeared in DSS News 12/22/02