Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc 3.x Guide
Previous Page Home 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.

Image:documentation_note.png To apply conditional formatting, AutoCalculate must be enabled. Choose Tools > Cell Contents > AutoCalculate.

Conditional formatting depends upon the use of styles. If you are not familiar with styles, please refer to Chapter 4. An easy way to set up the required styles is to format a cell the way you want it and click the New Style from Selection icon in the Styles and Formatting window.

After the styles are set up, here is how to use them.

  1. In your spreadsheet, select the cells to which you want to apply conditional formatting.
  2. Choose Format > Conditional Formatting from the menu bar.
  3. On the Conditional Formatting dialog, enter the conditions. Click OK to save. The selected cells are now formatted in the relevant style.
Conditional formatting dialog

Cell value is / Formula is

Specifies whether conditional formatting is dependent on a cell value or on a formula. If you select cell value is, the Cell Value Condition box is displayed, as shown in the example. Here you can choose from conditions including less than, greater than, between, and others.

Parameter field

Enter a reference, value, or formula in the parameter field, or in both parameter fields if you have selected a condition that requires two parameters. You can also enter formulas containing relative references.

'Cell style'

Choose the cell style to be applied if the specified condition matches. The style must have been defined previously.

See the Help for more information and examples of use.

To apply the same conditional formatting later to other cells:

  1. Select one of the cells that has been assigned conditional formatting.
  2. Copy the cell to the clipboard.
  3. Select the cells that are to receive this same formatting.
  4. Choose Edit > Paste Special.
  5. On the Paste Special dialog, in the Selection area, select only the Formats option. Make sure all other options are not selected. Click OK.
Paste Special dialog

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire