Difference between revisions of "Documentation/FAQ/Calc/Formatting/How can I use conditional formatting?"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Formatting
(fixing link syntax) |
m |
||
| Line 8: | Line 8: | ||
Formats in each cell can be based upon defined conditions. This function can be accessed through the drop-down menus: | Formats in each cell can be based upon defined conditions. This function can be accessed through the drop-down menus: | ||
| − | * Select | + | * Select {{menu|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. | 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. | ||
| Line 15: | Line 15: | ||
* [[Calc Conditional Formatting How To]] (to be written) | * [[Calc Conditional Formatting How To]] (to be written) | ||
* [[Documentation/How_Tos/Calc:_Functions_listed_by_category|Calc Functions]] | * [[Documentation/How_Tos/Calc:_Functions_listed_by_category|Calc Functions]] | ||
| − | * [ | + | * [https://www.lifewire.com/openoffice-calc-formulas-tutorial-3123953 About.com's Intro to Formulas] |
Latest revision as of 16:46, 16 May 2021
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
