Difference between revisions of "Documentation/FAQ/Calc/Formatting/How can I use conditional formatting?"

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Formatting
Jump to: navigation, search
(New page: {{DISPLAYTITLE: How can I use conditional formatting?}} <section begin=question/> '''How can I use conditional formatting?''' <section end=question/> <section begin=answer/> Formats in e...)
(Added some external links. (One is actually a wiki link but I couldn't figure out how to make it work))
Line 14: Line 14:
* [[Calc Conditional Formatting How To]] (to be written)
* [[Calc Conditional Formatting How To]] (to be written)
* Calc Functions [http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category]
* About.com's Intro to Formulas [http://spreadsheets.about.com/od/otherspreadsheets/ss/calc_formulas.htm]

Revision as of 22:40, 16 December 2010

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