Using Conditional Formatting

Getting Started with OpenOffice 4

Chapter 4: Getting Started with Calc

< Previous Section

Next Section >

• What is Calc
• Parts of the main Calc window
• Open and Save CSV files
• Navigating within spreadsheets
  • Going to a particular cell
  • Moving from cell to cell
  • Moving from sheet to sheet
• Selecting items in a sheet or a spreadsheet
  • Selecting Cells
  • Selecting Columns and Rows
  • Selecting Sheets
• Working with Columns and Rows
• Working with Sheets
• Viewing Calc
• Entering data using the keyboard
• Speeding up data entry
• Validating cell contents
• Editing data
• Formatting data
• Auto-formatting cells and sheets
• Formatting spreadsheets using themes
• Using conditional formatting
• Hiding and showing data
• Sorting records
• Using formulas and functions
• Analyzing data
• Printing from Calc
  • Using Print Ranges
  • Selecting the Page Order, Details, and Scale
  • Page Breaks
  • Headers and Footers

< Previous Page

Next Page >

Using Conditional Formatting

You can set up cell formats to change depending on conditions that you specify. For example, in a table of numbers, you can show all the values above the average in green and all those below the average in red. The feature is reached through Format → Conditional Formatting.

Conditional formatting depends upon the use of styles, and the AutoCalculate feature (Tools → Cell Contents → AutoCalculate) must be enabled. See Chapter 2 (Entering, Editing, and Formatting Data) in the Calc Guide for details.