aspect of the data tools lies in the visualization of those data for easy
understanding of the user. Conditional formatting gives different font size,
font colour and background colour for different data, based on the user
can set up cell formats to change font size, font colour, background colour
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.
example, the marks of the students are entered in the spreadsheet. The marks
should be shown in different colours for the different marks ranges.
Illustration 11.1: Apply the conditional formatting for Table 11.1 as for the condition given below.
Marks less than or equal to 50 in Lightgreen
Marks greather than 50 in blue
Select the cells which contain marks
Choose Format → Conditional Formatting from the menu bar
Conditional formatting dialog box appears as shown in Figure 11.2
Select Condition 1, choose cell value
is “greater than” and type 50 in the
Then click New Style button. The New
Style button has various options such as Font Style, Font Size, Font colour,
Font alignment, Border Colour, and Background colour.
the cell style dialog box appears as shown in Figure 11.3a will appear. Click
Background Tab and choose light green.
Similarly, Select Condition 2, choose cell value is “less than” and type 50 in
the value box. In the background tab, choose blue colour.
OpenOﬃce calc shows the result as given