Page 42 - Computer Genius Class 07
P. 42

4  Enter the value.












                                                                5  Click on the OK button.


                  This list shows various criteria like:

                      Highlight Cells Rules: This option is selected when you want to highlight all cells satisfying a
                     gi en condition.  hen you ho er mouse o er this option  it opens a su  list sho ing criteria li e
                      reater Than   ess Than    ual To   et een  etc.

                      Top/Bottom Rules: This option is selected when you want to highlight some top or bottom number
                     o  items in a data series.  hen you ho er mouse o er this option  it opens a su  list sho ing
                     criteria li e Top 1   tems  Top 1     ottom 1   tems   ottom 1    etc.

                      Data Bars: This option is selected when you want to add data bars to the cells having numeric
                     data.  hen you ho er mouse o er this option  it opens a su  list sho ing  ars o  di  erent types
                     and colours that can be added to the cells.
                      Colour Scales: This option is selected when you want to add colour schemes to all selected cells
                     slo ly  arying  rom top to  ottom items.  hen you ho er mouse o er this option  it opens a su
                     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
                     accepta le   hich are moderate and  hich need attention. The di  erent types o  icon sets that
                     can  e added are sho n in the su  list that opens  hen the mouse is ho ered o er this option.

                  The selected conditional  ormatting is applied to the selected cell range.  ou can also define your o n
                  rule for highlighting cells by selecting New Rule option from the Conditional Formatting drop do n list.
                  The conditional formatting features applied to a data range can be cleared by selecting Clear Rules
                  option from the Conditional Formatting drop do n list.























                      40     Computer Genius-VII
   37   38   39   40   41   42   43   44   45   46   47