Adding Trend Arrows

[pmpkinspice97]

I am trying to add trend arrows to my data based on the previous month. Please see the examples table below. Let's say we're looking at the data of orange crates sold each month for the last six months. January- 16, February- 6, March- 7, April- 4. May- 18 and June- 47. How would I get arrows to show if more or less oranges were sold in the previous month?

What I have:

January	February	March	April	May	June
16	6	7	4	18	47

What I want:

January	February	March	April	May	June
16	6↓	7↑	4↓	18↑	47↑

 

[Fluff]

Hi & welcome to MrExcel.
You can do that with conditional formatting using a custom cell format.

Fluff.xlsm
	A	B	C	D	E	F
1	January	February	March	April	May	June
2	16	6↓	7↑	4↓	18↑	47↑
Sheet6

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:F2	Expression	=B2>A2	text	NO
B2:F2	Expression	=B2<A2	text	NO

The custom cell format is 0↓ and 0↑

 

[pmpkinspice97]

Hi & welcome to MrExcel.
You can do that with conditional formatting using a custom cell format.

Fluff.xlsm
	A	B	C	D	E	F
1	January	February	March	April	May	June
2	16	6↓	7↑	4↓	18↑	47↑
Sheet6

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:F2	Expression	=B2>A2	text	NO
B2:F2	Expression	=B2<A2	text	NO

The custom cell format is 0↓ and 0↑

Thank you! I thought it would be conditional formatting but I wasn't quite sure how to make a rule that would help me do this! I appreciate your help. Do you mind showing me where I would create that rule?

 

[pmpkinspice97]

Thank you! I thought it would be conditional formatting but I wasn't quite sure how to make a rule that would help me do this! I appreciate your help. Do you mind showing me where I would create that rule?

Let me clarify actually. I know how to create the rule, but how do I apply it to multiple cells?

 

[Fluff]

Select the range of cells you want to apply it to & then goto CF & enter the rule.

 

[pmpkinspice97]

Thank you, Fluff. I am still having a hard time applying it to all cells but hopefully i can figure it out! If not, I suppose I can type out the format for every cell.

 

[pmpkinspice97]

Actually, I figured it out! We are set.

 

[Fluff]

Glad to help & thanks for the feedback.

 

[AFK_Matrix]

Sorry to resurrect this post but can the same thing be done in Google Sheets? If so I am not sure what formula needs to be entered in conditional formatting. I would also like to use these symbols instead ▲▲ if its possible.

Thank you.

 

[Fluff]

I know very little about Google Sheets, so I suggest that you start a thread of your own in the General Discussion & Other Applications section of the board.