64. Conditionally Format DataBEFORE YOU BEGIN 60 Format Cells 62 Set Up Calc Page Formatting SEE ALSO 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. KEY TERM 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:
NOTE 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. |