Conditional Cell Attributes

You can make the appearance of a cell change according to the value it contains, useful perhaps if you are using Calligra Sheets to keep track of your household expenses and want to highlight any item greater than, say, one thousand dollars.

To do this select the cell(s) then choose Conditional Styles... from the Format menu. This will bring up the Conditional Styles dialog box where you can make the font type and color of a cell change when the value meets one or more conditions. Note that the second and third conditions only apply if the previous condition(s) are not met.

Use ClearConditional Styles from the Edit menu to clear any conditional attributes from selected cells.