Often, you might want to add up and down arrows in Excel so that you can easily understand the increase and decrease in the price of your business commodities and stock price. Moreover, we can easily make 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.
How to Insert Red Arrow in Excel Cell: 5 Suitable Examples
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.
- 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: Double Headed Arrow in Excel
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!
- 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.
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.
- 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 the 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
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.
- 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 Up and Down Arrows in Excel
5. Insert Red Arrow Using Customized Format
Last but not 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!
- 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.
💬 Things to Remember
- Fortunately, you can insert any type of arrow as a 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.
Download Practice Workbook
You can download the workbook used for the demonstration from the download link below.
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.