Select the first cell of the data to which you want to apply conditional formatting.
Press Shift + ↓ (Down Arrow key) to select multiple cells. Press Alt + H + L + I (ai) + M.
The New Formating Rule dialog box will appear.
Press Alt + C to select Icon Style, then press ↓ (Down Arrow key) twice.
Press the ↑ (Up Arrow key) three times to select the arrow icon.
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.
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.
An arrow based on the specified condition is now displayed.
Please send us your comments on this article.