Page 67 - modular4.0
P. 67

Chapter Profile
                 The conditional formatting command has following options:
                    Highlight Cells Rules: This option is selected when you want to highlight all cells satisfying a
                    given condition. When you hover mouse over this option, it opens a sub-list showing criteria like

                    Greater Than, Less Than, Equal To, Between, etc.

                    Top/Bottom Rules: This option is selected when you want to highlight some top or bottom
                    number of items in a data series. When you hover mouse over this option, it opens a sub-list

                    showing criteria like Top 10 Items, Top 10%, Bottom 10 Items, Bottom 10%, etc.
                    Data Bars: This option is selected when you want to add data bars to the cells having numeric
                    data. When you hover mouse over this option, it opens a sub-list showing bars of different types
                    and colours that can be added to the cells.

                    Color Scales: This option is selected when you want to add colour schemes to all selected cells
                    slowly varying from top to bottom items. When you hover mouse over this option, it opens a
                    sub-list showing different colour variations that can be added to 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 sets that
                    can be added are shown in the sub-list that opens when the mouse is hovered over this option.

                 You can also define your own rule for highlighting cells by selecting New Rule option from the
                 Conditional Formatting drop-down list.
                 The conditional formatting features applied to a data range can be cleared by selecting Clear Rules
                 option from the Conditional Formatting drop-down list.


                        USING DATA VALIDATION


                 Data validation means to restrict the user to enter a specific range of values in a particular cell or a
                 range of cells. Perform the following steps to use data validation:

                                                                        4  Select Whole number from
                                                   2  Click on the      the Allow drop-down list.
                                                   Data tab.




                                                   3  Click on the
                                                   Data Validation
                                                   command.



                                                   1  Select the cell
                                                   or a range of cells
                                                   on  which you
                                                   want  to  apply
                                                   data validation.     5  Enter 0 and 100 in the Minimum
                                                                        and Maximum textboxes.






                                                                                                   Excel as Database  65
   62   63   64   65   66   67   68   69   70   71   72