Share via

how to add arrow symbol to a cell value in excel

Anonymous
2024-08-19T07:47:26+00:00

I had a w/sheet, column D values are derived from a formula. The values are mixed with positive and negative values. How to add 45 degrees red arrow along with negative values and 135 degrees green arrow to positive values. I want to learn both methods a. along with values in column D, b. only arrow symbols in separate column say in Column E.

A B C Dr/Cr.values E F
-25
600
-429
2
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2024-08-19T12:09:50+00:00

    See the first screenshot in my previous reply for the correct settings.

    You can copy the custom format string [Green]"↗";[Red]"↘" from this post.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-19T11:08:27+00:00

    Thank you Hans. But I didn't get desired results. All my debits (minus number values) be Red upper icon and all positive numbers with green down arrow.

    for 2nd part custom format>>after [Green] how to insert arrow symbol in " "

    0 comments
  2. HansV 462.6K Reputation points MVP Volunteer Moderator
    2024-08-19T09:36:01+00:00

    Arrow symbols in column D: Excel does not have a conditional format style with diagonal red and green arrows. You'll have to use vertical arrows.

    Select the cells with numbers in column D.

    On the Home tab of the ribbon, select Conditional Formatting > New Rule...

    Select 'Format all cells based on their values'.

    Select 'Icon Sets' from the 'Format Style' drop-down.

    Select the set with a red down-arrow, yellow horizontal arrow and green up-arrow.

    Select Number from both Type drop-downs.

    Result:

    Arrow symbols in column E:

    Select the cells in column E to the right of the numbers in column D, for example E2:E5.

    Enter the formula =D2:D5.

    Apply the custom number format

    [Green]"↗";[Red]"↘"

    to the selection. Result:

    0 comments