Page 58 - Excel Data Analysis
P. 58

04 537547 Ch03.qxd  3/4/03  11:50 AM  Page 44







                     EXCEL DATA ANALYSIS



                  APPLY CONDITIONAL

                  FORMATTING (CONTINUED)



                       fter you select conditions, you must specify the  assume you want all values over 1,000 to appear in blue
                       formatting you want to apply via the Format button  font, and the values between 1,500 and 2,000 to appear in
                  A in the Conditional Formatting dialog box. The Format  green font, and you create two conditional format
                  Cells dialog box has three tabs for setting the formatting  statements and apply them. If the conditional formatting
                  you want: Font, Border, and Patterns. When you close the  definitions are in that order, all values such as 1,555 or 1,900
                  dialog box, you can view selected formatting in the Preview  will appear in blue because they meet the condition of the
                  window of the Conditional Formatting dialog box and  first definition, greater than 1,000 in blue, and Excel ignores
                  decide if it is what you want. See Chapter 1 for more  the second conditional formatting definition.
                  information about formatting cells.
                                                                      To make the conditional formatting work correctly, you
                  You can create up to two further definitions, making a total  must place the formatting for values between 1,500 and
                  of three conditional formatting definitions for the selected  2,000 first, followed by the conditional formatting for values
                  range. Remember that if Excel encounters cells that meet  over 1,000. Therefore, it is extremely important to ensure
                  more than one of the conditional formatting definitions, it  that the conditional formatting definition that covers the
                  only applies to the first one. If you are not careful about  broadest range of values appears last, such as the greater
                  how you lay out your conditional formatting statements,  than 1,000 definition.
                  you may not achieve the results you desire. For example,

                   APPLY CONDITIONAL FORMATTING (CONTINUED)


























                  ■ The Format Cells dialog   ‡ Specify the format for the   ■ The Preview field displays   · Click Add.
                  box displays.             condition.                a sample of the formatting
                                                                      selections.
                                            ° Click OK.





                   44
   53   54   55   56   57   58   59   60   61   62   63