Mehedi Hasan
Often, you might want to add up and down arrows in Excel so that you could easily understand the increase and decrease in the price of your business commodities and stock price. Moreover, we can easily take a decision from the up and down arrows from the price of the business commodities and stock. Fortunately, adding up and down arrows is an easy task. In this article, you will learn how to insert a red arrow in an Excel cell with five quick and suitable examples.
Download Practice Workbook
You can download the workbook used for the demonstration from the download link below.
5 Suitable Examples to Insert Red Arrow in Excel Cell
You can insert a red arrow in Excel without using any functions. For the purpose of demonstration, I have used the following sample dataset and five different scenarios to provide you with a better idea about the operation. Let’s say, we have a dataset that contains information about several stock companies. It contains the daily change for a particular date. Hence, I want to insert red arrows in order to show the ups and downs of the prices.
1. Insert Red Arrow as Symbol
You can use symbols as indicators in Excel. Fortunately, you can easily find arrows from a variety of symbols in Excel. Hence, go through the following steps in order to insert a red arrow as a symbol.
📌 Steps:
- Firstly, select the cell where you want to add an arrow as a symbol.
- Secondly, go to the Symbols option from the Insert tab.
- Secondly, from the Symbol dialog box select the arrow you want to insert and press Insert and Close.
- Thirdly, a black arrow will appear and change the color to red from the Color command.
- Similarly, you can add arrows according to your choice as in the below image.
Read More: How to Draw Arrows in Excel (3 Simple Ways)
2. Insert Red Arrow Using Conditional Formatting
In this section, I will apply Conditional Formatting to add up and down arrows in Excel. From the dataset, you can easily add up and down red arrows. Let’s follow the instructions below to add up and down arrows!
📌 Steps:
- At first, select the C5 cells and go to the Home tab.
- After that, go to the Styles command and then go to Conditional Formatting → Icon Sets → Directional (Select any Set).
- Lastly, you will see directional arrows as in the following image.
Read More: Up and Down Arrows in Excel Using Conditional Formatting
3. Insert Red Arrow as Wingdings 3 Font in Excel
Furthermore, you can insert up and down red arrows changing the Font. Moreover, you can easily do that and this is a time-saving task also. Hence, follow the below steps in order to complete the operation.
📌 Steps:
- First of all, select the D5Â cells.
- Then, select Font as Wingdings 3 and Red from Font Color from the Fonts command.
- Next, select the Hash(#) and Dollar($) signs which will convert into up and down arrows respectively, and press Enter key.
- After that, write the Dollar($) sign to get the down arrow.
- Finally, you will get your desired result.
Read More: How to Add Trend Arrows in Excel (3 Suitable Ways)
4. Insert Red Arrow as a Shape
After all, you can insert a red arrow as a shape. You can select and insert multiple arrows in a particular cell by using this procedure. Hence, follow the steps below in order to complete the task properly.
📌 Steps:
- Firstly, select a cell you want to insert a red arrow.
- Secondly, click on the Insert tab and go to Illustrations → Shapes → Block Arrows (Select any).
- Thirdly, a block arrow will appear and change the fill color to red from the Shapes Style.
- Finally, change the size of the arrow according to your choice. Similarly, you can add arrows to other data as in the below picture.
Read More: How to Add Arrow in Excel Graph (with Easy Steps)
5. Insert Red Arrow Using Customized Format
Last but not the least, I will perform the Custom command to add up and down arrows in Excel. You can easily do that from the given dataset. Moreover, you will get the arrows automatically according to the data. Now, Let’s follow the instructions below to add up and down arrows!
📌 Steps:
- Firstly, select cell C5.
- Secondly, press Ctrl+1 on your keyboard and the Format Cells dialog box will appear.
- From the Format Cells dialog box, firstly, select the Number Secondly, select Custom from the Category drop-down list.
- Further, type [Green]0.00%↑;[Red]0.00%↓ in the Type box and press OK.
- Finally, the final output will appear in the following image.
Read More: How to Insert Trend Arrows Based on Another Cell in Excel
💬 Things to Remember
- Fortunately, you can insert any type of arrow as symbol.
- Unfortunately, you can’t only add red arrows according to your choice. Red, green, and yellow color arrows will be added automatically according to the data.
- Whether you use the symbol or font, you have to change the arrow color to red manually.
- If you use a customized format, green and red color arrows will be inserted automatically. You can’t opt out of the green one.
Conclusion
These are all the steps you can follow to add a red arrow in Excel. Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.
For more information like this, visit Exceldemy.com.
