Page 66 - modular4.0
P. 66

Chapter Profile



                           5  Enter 80 in
                           the criteria box.                                                   6  Click on the

                                                                                               OK button.


                  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 Sort & Filter group under the Data tab by selecting
                      Filter command        .





                         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 Excel. To apply conditional formatting to a series of data, follow the given steps:

                             1   Select  the  data  and  click  on  the   2   Select  the  desired
                             Conditional Formatting command.           conditional formatting.










                                                                                         3  Now select the desired
                                                                                         option  to  apply  on  the
                                                                                         selected cell range.












                  The selected conditional formatting is applied to the selected cell range.




                64   Modular (Ver. 4.0)-VII
   61   62   63   64   65   66   67   68   69   70   71