Excel Hack

Up and Down Arrows in Excel conditional formatting

Using Excel’s icon set, you can indicate the up and down values of the data in a selected range with arrows. If you can use up and down arrows to indicate trends in your data, you will be able to manage your data better. In the following, we will show you how to apply up and down arrows to data from conditional formatting. We will also show you how to change the conditions.

Shortcut to add up and down arrows in conditional formatting

Display the icon set

Windows
Access Key: Alt + H + L + I (ai)

Mac
None

Display the New Formating Rule dialog box

Windows
Access Key: Alt + H + L + I (ai) + M

Mac
None

Apply up and down arrows to data

Learn how to use the shortcut keys to apply up and down arrows to your data.

Total Time: 1 minute

Select a cell

Select a cell

Select the first cell of the data to which you want to apply conditional formatting.

Select a range

Select a range

Press Shift + (Down Arrow key) to select multiple cells.

Select an arrow from the icon set

Select an arrow from the icon set

Press Alt + H + L + I (ai), then press Enter.

Up and down arrows applied to data

Up and down arrows applied to data

The arrow has been applied to the data.

Change the conditions and apply the up and down arrows

Select a cell

Select the first cell of the data to which you want to apply conditional formatting.

Press Shift + ↓

Press Shift + (Down Arrow key) to select multiple cells. Press Alt + H + L + I (ai) + M.

Press Alt + C, ↓

The New Formating Rule dialog box will appear.

Press Alt + C to select Icon Style, then press (Down Arrow key) twice.

Press ↑

Press the (Up Arrow key) three times to select the arrow icon.

Press Alt + T,N

Press Alt + T to specify the type of condition, and press N to set the type to a number.

Set both the top and bottom types to number.

Change the value

Press Alt + V to change the value.

This time, we will set the values to display an up arrow for values above 1300, a down arrow for values below 800, and a horizontal arrow for values between 800 and 1300.

Once you have entered the value, press Enter.

I was able to apply the arrows

An arrow based on the specified condition is now displayed.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments