Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 33 - 2626_South Point_C-7
P. 33

    Color Scales: This option is selected when you want to add colour
                       schemes to all selected cells slowly varying from top to bottom                   Factopedia
                       items. When you hover the mouse pointer 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  pointer  is       Freeze Panes feature
                       hovered over this option.                                                     allows you to lock

                     Step 3:   Select  the  desired conditional  formatting.  In this  case,  we   your column/row so
                             have selected the Orange Data Bar option under the Data               that, when you scroll

                             Bars category. The selected conditional formatting is applied          down or up to view
                             to the selected cell range.                                           the rest of your sheet,
                                                                                                    the locked column/
                                                                                                    row remain on the
                                                                                                          screen.

                                                                                                        The earliest
                                           Using conditional formatting
                                                                                                     date allowed for
                     You can also define your own rule for highlighting cells by selecting        calculations in Excel is
                     New Rule option  from the  Conditional  Formatting drop-down list.              January 1, 1900.
                     The conditional formatting features  applied  to  a data  range can
                     be  cleared  by  selecting  Clear Rules option  from the  Conditional
                     Formatting drop-down list.

                                Let’s BaCk-uP

                            Sorting data means to organise the data in ascending or
                          descending order.
                                                                                                  If you need 1 second to
                            Custom sorting is used to apply sorting on more than one               fill out 1 cell, it would
                          column in selected range on different criteria.                          take you 545 years to
                            The filters can be easily applied and removed according to the          complete the whole
                          user’s requirements.
                                                                                                        worksheet.
                            Conditional formatting can be applied on the basis of different
                          criteria.

                                                                                            Advanced Features of Excel  31

| 28 29 30 31 32 33 34 35 36 37 38 |