How can I use conditional formatting?

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Formatting
Jump to: navigation, search


How can I use conditional formatting?


Formats in each cell can be based upon defined conditions. This function can be accessed through the drop-down menus:

  • Select Format - Conditional Formatting...

In the dialog box that appears, enter the conditions that determine the formats and the desired formats for each condition. If more help is needed to understand the settings, click the Help button in the dialog box, and a new help window opens with a description of all the fields shown in the dialog box. The help file also shows the path to a sample file that uses conditional formatting for reference.


See Also:


Personal tools