"The twists and turns" Excel skill hundred example 01. Compare two columns of data and then give the relevant identification according to the data lifting

First look at table one and table two below:

Form one:

Table Two:

Here's how to add a column to table one, which describes the ascending and descending relationships between the first column and the second column of data and distinguishes it with arrows and colors.

The first step:

Insert a column, and write a name in the title, for example: Change trend, rise/fall, etc. can be.

Step Two:

Fill in the formula on the newly added column, such as D3=B3-C3, and then press and hold the D3 cell and drag it down to D12.

Step Three:

On the newly added column, right-click on "Format Cells" and click on Customize, enter in the Custom box: [Color 3][>0]↑* 0; [Color 50] [<0]↓* 0, click OK.

Note:

1) [>0] is the expression condition, between the conditions with a semicolon ";" To split

2) [Color 3],[color 50] is the built-in color of Excel, can be replaced by itself

3) ↑ and ↓ are two special characters that can be changed by themselves

So I can see the form of form two.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

"The twists and turns" Excel skill hundred example 01. Compare two columns of data and then give the relevant identification according to the data lifting