Page 76 - TechPluse_C6_Flipbook
P. 76
Step 5 Click on the Condition drop-down list and select >.
Step 6 Click on the Value text box and type 80.
Step 7 Click on the OK button.
You will notice that only the details of the students who have obtained marks greater than 80 are
displayed and the remaining rows get hidden.
Remove Filters
The filters once applied can be easily removed. Click anywhere in the worksheet and repeat steps
to apply filters. You will notice that the filter arrows in front of column headers disappear and the
hidden rows also reappear.
Clickipedia
The filter can also be applied through AutoFilter tool ( ) on Standard toolbar.
CONDITIONAL FORMATTING
Suppose you do not want to hide any rows but still want to highlight all the cells that satisfy
a condition, for example greater than 80. This type of formatting is known as Conditional
Formatting in Calc. To apply conditional formatting to a series of data, follow these steps:
To apply conditional formatting to a series of data, follow these steps:
Step 1 Select the data to which formatting is to be applied.
Step 2 Click on the Format menu.
Step 3 Hover the mouse pointer over the Condition option. A submenu opens. This submenu
shows various criteria like:
Condition: This option is selected to give same result as Standard Filter. The
difference is that the rows that do not satisfy the condition are not hidden.
Instead, the cells satisfying the condition get formatted as bold.
Colour Scale: This option is selected when you want to add colour schemes to
all selected cells slowly varying from top to bottom items. When you click on
this option, it opens a dialog box showing different colour variations that can be
added to cells.
Data Bars: This option is selected when you want to add data bars to the cells
having numeric data. When you click on this option, it opens a dialog box showing
bars of different types and colours that can be added to the cells.
Icon Sets: This option is selected when you want to add icon sets to show which
cells are acceptable, which are moderate and which need attention. The different
types of icon set that can be added are shown in the dialog box that opens when
the mouse is clicked on this option.
Date: This option is selected when the data involved consists of lots of dates.
74 Premium Edition-VI

