Make a concise project schedule

 Specific to the completion schedule of the project in this example, it is assumed that the entire project schedule includes 7 stages as shown in the figure, and the project is divided into 6 projects from A to F. If all 7 stages are indicated as “√”, then “Completed” and full signal icons will be displayed in the “Complete State”; if there are 4 to 6 “√” in 7 stages, then the “Completed State” will be Display “in progress” and 3 grid signal icons; if there are 1 to 3 “√” in 7 stages, then “in progress” and 2 grid signal icons will be displayed in “Complete Status”; if in 7 stage cells If there is no “√”, the “Not Started” and full space signal icons will be displayed at the “Complete Status”. Let’s start production below.
  First, we enter the statistical formula “= COU NTIF (B2: H2,” √ “)” in the “I2” cell, count the number of “√” in “B2: H2”, and then fill down to count the front The number of “√” (Figure 2).
  Secondly, select the data area of ​​column I, right-click, select “Set Cell Format”, in the pop-up window “Number” tab under “Classification”, select “Custom”, enter “[<1]" as the type Start "; [<7]" In progress ";" Completed ";". This type means: less than 1, it displays "not started"; less than 7, it displays "in progress"; otherwise it displays "completed" (Figure 3).   Next set the icon set. Select the data area of ​​column I, switch to the "Start" tab, click "Style → Conditional Format → Icon Set → Other Rules", and select the "Four Levels" group in the "Icon Style" of the pop-up window (Of course, you can also Choose your favorite style according to your needs), set the following "type" to "number", the first group is "> 6″, the second group “> = 4”, the third group “> = 1”, OK Just (Figure 4).
  Finally, make the necessary settings for the table style.