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
   71   72   73   74   75   76   77   78   79   80   81