Home > Topics > excel > body text

Example Analysis: How to use conditional formatting to create a project progress chart in Excel

WBOY
Release: 2022-06-28 11:53:14
forward
3949 people have browsed it

This article brings you relevant knowledge about excel, which mainly organizes related issues on how to use conditional formatting to create project progress charts, including building a framework, setting cell formats, etc. Let’s take a look at the content below. I hope it will be helpful to everyone.

Example Analysis: How to use conditional formatting to create a project progress chart in Excel

Related learning recommendations: excel tutorial

Today we share a simple and practical method of making a project progress chart. Let’s take a look at the effect first. :

Example Analysis: How to use conditional formatting to create a project progress chart in Excel

Next let’s take a look at the specific steps.

The first step: first build a framework.

Enter the subproject name and start and end dates in columns A, B, and C respectively.

Enter the project construction date at D2:X2.

Example Analysis: How to use conditional formatting to create a project progress chart in Excel

Step 2: Set the cell format.

Select D3:X3 and set the cell to a light gray lower border.

The cursor is close to the lower right corner of cell X3 and drag the fill handle downward.

Example Analysis: How to use conditional formatting to create a project progress chart in Excel

Step 3: Set conditional formatting.

Select D3:X6, [Start] → [Conditional Formatting] → [New Rule] → Use the formula:

=(D$2>=$B3)*(D$2< ;=$C3)

Click the [Format] button to set the fill color.

Pay attention to the changes in the reference method in the formula.

Example Analysis: How to use conditional formatting to create a project progress chart in Excel

Step 4: Set today’s line

Select D3:X6, [Start]→[Conditional Formatting]→[New Rule]→Use the formula as :

=D$2=TODAY()

Click the [Format] button and set the right border to red.

Example Analysis: How to use conditional formatting to create a project progress chart in Excel

OK, let’s take a look at the effect:

Example Analysis: How to use conditional formatting to create a project progress chart in Excel

If you want to show the progress percentage, the following effect is also good:

Example Analysis: How to use conditional formatting to create a project progress chart in Excel

##The formula of cell C2 is:

=REPT(“|”,B2*100)

Then set the font to Stencil. Can.

Related learning recommendations:

excel tutorial

The above is the detailed content of Example Analysis: How to use conditional formatting to create a project progress chart in Excel. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:csdn.net
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template