Page 41 - Touchpad_Plus_V3.2_Class 7
P. 41
Standard Filter can also be easily removed. Perform the following steps to remove the Standard Date: This option is used when the data consists of multiple dates. For this example,
Filter: we will use the Condition option.
Step 1 Click on the range of data, without headers, where the Standard Filter has been applied.
Step 2 Click on the Data menu.
Step 3 Click on the More Filters option.
Step 4 Click on the Reset Filter option.
The hidden rows will reappear.
Clickipedia
The filter can also be applied through AutoFilter tool on Standard toolbar.
If Calc was a magical library, how would you sort books and filter books you
had read?
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, employees having more than 2 years of experience. This type of formatting Using Conditional Formatting
is known as Conditional Formatting in Calc.
Step 4 Click on the Condition option.
Perform the following steps to apply conditional formatting to a series of data:
Step 5 Click on the Greater than option. The Apply conditional formatting dialog box will
Step 1 Select the range of data to which the
open.
formatting should be applied.
Step 6 In the Apply conditional formatting dialog box, type 2 in the value box and choose
Step 2 Click on the Format menu. Accent 3 for the formatting style.
Step 3 Click on the Conditional option to open
Step 7 Click the OK button.
a submenu. This submenu shows various
criteria, such as:
Condition: This option works similarly to the Standard Filter. The difference is that
rows that do not satisfy the condition are not hidden; instead, the cells that meet the
condition are formatted (e.g., in bold).
Colour Scale: This option applies a color gradient across all selected cells, with
colors varying from top to bottom. When you click this option, a dialog box opens
displaying various color gradients you can apply.
Data Bars: This option adds data bars to cells containing numeric data. When you
Apply conditional formatting dialog box Conditional Formatting applied
click on this option, a dialog box opens showing different types and colors of bars
that can be added to the cells. The selected conditional formatting is applied to the selected cell range. You can also
Icon Sets: This option adds icon sets to visually indicate which cells are acceptable, define your own rule for highlighting cells by selecting Manage option from the Conditional
moderate, or need attention. The dialog box that opens shows various icon sets that submenu.
can be applied to the cells.
More on Calc 39

