A new format template under OpenOffice Calc to create
First of all, you need to create a format template that you can then use in the appropriate cells.
- Press F11 to get into the "styles"menu.
- Right-click in the window and select "New...".
- Enter a name for the format template and format Tabs of the format template according to your needs. Later on, each cell that uses this format template will look like so. For example, you can select in the Tab "Background" with a green Background for revenue.
A format template, create
Conditional formatting to desired cells
Now you can specify the desired cells to the previously created formatting to be applied under certain conditions:
- Select the cells where the conditional formatting is to be effective.
- From the menu, select "Format" and "Conditional formatting".
- You create your condition. You want to create more than one condition, you must select the Checkboxes next to "condition 2", etc. Note that the formatting is used, the first applies. To take, for example, condition 1 and 2 is selected in the formatting condition 1.
- In our example, we select the condition as follows: We leave the first selection list in the "cell value is" and select the second "greater than". In the text box we type in the number 0, and select "receipts" from the list of format templates.
- The terms and conditions, available under "cell value is" are you simple, you can select "formula is", and so the usual formulas in the conditional formatting use.
The format cells conditionally
Was used OpenOffice in Version 4.0.0. For more practical tips to OpenOffice find you here. Some useful extensions of OpenOffice in a picture gallery before.
