OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources] نسخه متنی

1.

Request Conditional Formatting

Click to select the cell or range on which you want to apply a conditional format. Select Conditional Formatting from the

Format menu. The Conditional Formatting dialog box appears.

2.

Enter the Format Conditions

You can apply up to three conditions for the cell you've selected to format conditionally. Most often, you'll probably only need to use a single conditional format.

Click to select either

Cell value is or

Formula is to indicate how the conditional format is to apply. If the format depends on a value, as it usually will, select

Cell value is . If the format depends on a formula, select

Formula is and enter a cell reference for that formula to the right of the option.

Select the

Cell Style setting that you want Calc to use for the data's display if the condition is met by data within the cell. Any time the data changes to make the condition true, Calc applies the format style to the cell.

65 About Calc Styles and Templates ).

Select the condition, such as

Less than . If the cell's value ever goes below the value you enter next to the condition, Calc changes the cell's format to match the style you select. Two of the conditions,

Between and

Not between , require two values for the condition to be matched. If you select either of these conditions, Calc provides two text boxes so you can enter both values that define the condition.

3.

View the Spreadsheet Again

The Conditional Formatting dialog box consumes quite a bit of space, and while you're filling it in, you may need to see your data on the sheet beneath the dialog box. If so, click the

Shrink button. Calc temporarily shrinks the

Conditional Formatting dialog box to a thin line so you can view the spreadsheet once again.

Click the

Shrink button once again to return the Conditional Formatting dialog box to its original size so that you can complete the formatting. After setting up the conditional format, click

OK to apply it.

4.

Test the Format

If the cell never matches the condition, the cell's format will remain unchanged. If, however, the cell does pass the condition, Calc applies the format so it becomes noticeable to anyone looking at the spreadsheet.