Home  >  Article  >  Topics  >  How to automatically mark rising or falling arrows in Excel while calculating function comparisons

How to automatically mark rising or falling arrows in Excel while calculating function comparisons

coldplay.xixi
coldplay.xixiOriginal
2020-09-01 11:10:2722625browse

How Excel automatically marks rising or falling arrows while calculating function comparisons: First select the cell and click Conditional Formatting; then click the icon and select the [Manage Rules] option under the Conditional Formatting column; Then enter the edit rule page to edit; finally sum the data.

How to automatically mark rising or falling arrows in Excel while calculating function comparisons

【Related learning recommendations: excel basic tutorial

How Excel automatically marks rising or falling arrows while calculating function comparisons:

1. Find and open the table file that needs to be operated in the computer wps, as shown in the figure below .

How to automatically mark rising or falling arrows in Excel while calculating function comparisons

2. Select the cells that need to be calculated and add arrows, as shown in the figure below. Click the "Conditional Formatting" option in the upper right to enter the next page, as shown in the figure below. shown.

How to automatically mark rising or falling arrows in Excel while calculating function comparisons

#3. In the pop-up setting options dialog box, select a set of arrow styles under the "Icon Set" column, as shown in the figure below, to enter the next page.

How to automatically mark rising or falling arrows in Excel while calculating function comparisons

#4. Then select the "Manage Rules" option under the conditional formatting column and click to enter the next page, as shown in the figure below.

How to automatically mark rising or falling arrows in Excel while calculating function comparisons

5. Enter the edit rules page. For example, you need to mark the three subjects in the table with a total score of more than 200 points as a green upward arrow, and those with a total score of less than 200 points as a red arrow. Downward arrow, set as shown below, click OK to proceed to the next step.

How to automatically mark rising or falling arrows in Excel while calculating function comparisons

#6. Now return to the form and perform calculations in the total score column, as shown in the figure below.

How to automatically mark rising or falling arrows in Excel while calculating function comparisons

7. At this time, you can see that the total score cell in the three subject scores in the table not only has the calculation result but also a corresponding arrow in it. Completed EXCEL automatically marks rising or falling arrows while calculating function comparison, as shown in the figure below.

How to automatically mark rising or falling arrows in Excel while calculating function comparisons

The above is the detailed content of How to automatically mark rising or falling arrows in Excel while calculating function comparisons. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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