64. Conditionally Format Data
BEFORE YOU BEGIN
60 Format Cells
62 Set Up Calc Page Formatting
70 Protect Spreadsheet Data
Conditional formatting enables you to make your spreadsheets respond to the data they contain. When certain conditions arise, you can draw attention to particular cell entries by automatically making those cells display differently from the cells around those exceptions.
Conditional formatting The process of formatting cells automatically, based on the data they contain. When the data changes and triggers a predetermined condition, Calc automatically changes the cell's format.
64. Conditionally Format Data.
Most often, users place conditional formats on cells that they want to watch (for example, for extraordinarily high or low conditions that might require special attention).
The way you indicate if a condition is met is to specify a value and a condition that must become true before the format takes place. Here's a list of the available conditions:
Calc constantly monitors cell contents. Every time you enter a new value or the spreadsheet recalculates, Calc tests all the conditional formats and applies any of those formats if needed.