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
(Added some external links. (One is actually a wiki link but I couldn't figure out how to make it work))
(fixing link syntax)
 
Line 14: Line 14:
 
{{SeeAlso}}
 
{{SeeAlso}}
 
* [[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]
+
* [[Documentation/How_Tos/Calc:_Functions_listed_by_category|Calc Functions]]
* About.com's Intro to Formulas [http://spreadsheets.about.com/od/otherspreadsheets/ss/calc_formulas.htm]
+
* [http://spreadsheets.about.com/od/otherspreadsheets/ss/calc_formulas.htm About.com's Intro to Formulas]
  
  

Latest revision as of 07:08, 17 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