Page 57 - ModularV1.1 _c7_flipbook
P. 57

Colour Scales – This option is selected when you want to add colour schemes to all

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

                            this option.
                                                                         Using Conditional Formatting
                 The  selected  conditional  formatting  is applied to  the
                 selected cell range. You can also define your own rule for
                 highlighting cells by selecting the New Rule option from

                 the Conditional Formatting drop-down list.
                 The conditional formatting  features  applied to a data
                 range can be cleared by selecting the Clear Rules option
                 from the Conditional Formatting drop-down list.                    Conditional Formatting applied

                     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:
                 Step 1   Select the cell or range of cells on which you want to apply data validation.
                 Step 2   Click on the Data Validation command from the Data Tools group of the Data tab. A
                         drop-down list appears.

                 Step 3   Select the Data Validation option. The Data Validation dialog box appears with the
                         Settings tab selected.
                 Step 4   Select the desired  option from the  Allow
                         drop-down  list.  In  this  case,  we  have  selected
                         Whole number option.
                 Step 5   Enter the minimum and maximum values in the
                         Minimum and Maximum textboxes.  In this case,
                         we have typed 1 and 31 respectively.





                                                                                        Data Validation dialog box



                                                                                              Excel as Database   55
   52   53   54   55   56   57   58   59   60   61   62