Teach you to make a project status table with Excel
Today, Mr. Wang teaches you to use Excel icons and digital format to create a beautiful project status table.
The result shows that there are multiple links in the table. Every time we finish a link, we can type "1" in the cell, and it will automatically become a "√" hook. When there is no "√", the completion progress displays "not started" and a red cross icon. When all is complete, the completed and green hook icons are displayed. If you are only completing individual steps, the "in Progress" and yellow exclamation mark icons will be displayed.
Make table ① select all link cells, "right"-"format cells"-"Custom" enter in the type:
[= 1] "√"; at this point, as long as we type "1" into these cells, we will immediately become a "√" hook.
② enters the formula in the "H" column data area:
= COUNTIF (B2:G2, "1") will automatically count the number of hooks.
③ select the "H" column data area, "right"-"format cells"-"Custom", and enter:
[