How to automatically mark rising or falling arrows in Excel while calculating function comparisons
- coldplay.xixiOriginal
- 2020-09-01 11:10:2722650browse
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.
【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 .
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.
#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.
#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.
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.
#6. Now return to the form and perform calculations in the total score column, as shown in the figure below.
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.
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!