Calc Guide

Figure 45: Conditional formatting dialog
Cell style
Choose the cell style to be applied if the specified condition
matches. The style must have been defined previously.
See the Help for more information and examples of use.
To apply the same conditional formatting
later to other cells:
1) Select one of the cells that has been
assigned conditional formatting.
2) Copy the cell to the clipboard.
3) Select the cells that are to receive this
same formatting.
4) Choose Edit > Paste Special.
5) On the Paste Special dialog, in the
Selection area, select only the Formats
option. Make sure all other options are
not selected. Click OK.
62 OpenOffice.org 3.x Calc Guide