IBM Lotus Symphony


Conditional Formatting

Choose Cell Formatting Conditions to define format styles depending on certain conditions.

If a style was already assigned to a cell, it remains unchanged. The style entered here is then evaluated. You can enter three conditions that query the contents of cell values or formulas. The conditions are evaluated from 1 to 3. If the condition 1 matches the condition, the defined style will be used. Otherwise, condition 2 is evaluated, and its defined style used. If this style does not match, condition 3 is evaluated.

To access this command...

Choose Layout - Cell Formatting Conditions

Warning Icon To apply conditional formatting, Instant Calculate must be enabled. Choose Tools - Cell Contents - Instant Calculate (you see a check mark next to the command when Instant Calculate is enabled).

Condition 1/2/3

Mark the boxes corresponding to each condition and enter the corresponding condition. To close the dialog, click OK.

Cell Value / Formula

In the field below Condition 1/2/3, specifies if conditional formatting is dependent on a cell value or a formula. If you select a formula as a reference, the Cell Value Condition box is displayed to the right of the Cell value/Formula field. If the condition is "Formula is", enter a cell reference. If the cell reference is a value other than zero, the condition matches.

Cell Value Condition

In the field next to "Cell Value/Formula", choose a condition for the format to be applied to the selected cells.

Cell Style

Choose the style to be applied if the specified condition matches.

Parameter field

In the field next to "Cell Value Condition" field, enter a reference, value or formula in the parameter field, or in both parameter fields if you have selected a condition that requires two parameters. You can also enter formulas containing relative references.

Once the parameters have been defined, the condition is complete. It may appear as:

Cell value is equal 0: Cell style Null value (You must have already defined a cell style with this name before assigning it to a condition).

Cell value is between $B$20 and $B$21: Cell style Result (The corresponding value limits must already exist in cells B20 and B21)

Formula is SUM($A$1:$A$5)=10: Cell style Result (The selected cells are formatted with the Result style if the sum of the contents in cells A1 to A5 is equal to 10.

Shrink / Maximize

Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.

The dialog is automatically minimized when you click into a sheet with the mouse. As soon as you release the mouse button, the dialog is restored and the reference range defined with the mouse is highlighted in the document by a blue frame.

{ENTER ALTERNATE DESCRIPTION HERE} Shrink
{ENTER ALTERNATE DESCRIPTION HERE} Maximize

Product Feedback | Additional Documentation | Trademarks