+ Reply to Thread
Results 1 to 3 of 3

Showing progress with arrows

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    Showing progress with arrows

    I have a table with three rows that each has a numerical value. For example: Price - 3$ - 4.5$ - 2$. I am trying to create a formula that displays a green arrow if the price has increased (3$ to 4.5$) a red arrow if the price has decreased (4.5$ to 2$) and a yellow arrow when the number stayed the same.

    I could just add these arrows manually but I have several columns with different numerical values and I need a dynamic functions that looks at the first numerical value and ads an arrow depending on how much the numerical value increased/decreased from the previous cell.

    Is there any way to do this?

    Thanks!

  2. #2
    Registered User
    Join Date
    05-29-2013
    Location
    Kolkata, India
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Showing progress with arrows

    Use a change column to find the change in price. Then use conditional formatting to show green arrow for change >0 , yellow for change=0, red for change <0.
    Prices Change
    $1.00
    $5.00 $4.00 =a3-a2
    $4.00 $(1.00) =a4-a3
    $3.00 $(1.00) =.....
    $8.00 $5.00
    $6.00 $(2.00)
    $4.00 $(2.00)
    $4.00 $-
    $5.00 $1.00
    $6.00 $1.00
    $7.00 $1.00
    $7.00 $-
    $9.00 $2.00
    $4.00 $(5.00)

  3. #3
    Registered User
    Join Date
    06-26-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Showing progress with arrows

    Is there any way to do this without adding an extra column? Because I will have several price columns and putting a column in between each one will make the table much wider.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1