Subscribe!

For quick and easy up and down trend arrows in your dashboards¬†and scorecards there is a simple solution…Marlett. If you do not know about this trick, you are probably unfamiliar with the Marlett font in Excel. Marlett was created by Microsoft for Windows and is used as the user interface font in many Microsoft applications. For our purposes, we will be using the up and down arrows.

To create up and down arrows, type a lower case t in Excel and change the font type to Marlett. You will see this changed to an up arrow. To create a down arrow, simply type a u.

To go a little farther with this idea, you can add conditional formatting to change the arrow to green when it is an up arrow and to red when it is a down arrow. Example:

up and down arrows in excel

the conditional formatting is set as “equal to =”t”" set to green bold, “equal to =”u”" set to red bold.

Joseph Harris
Excel Help

If you found this article helpful, buy me a cup of coffee!

Related posts:

  1. Conditional Formatting Q: Dear ExcelYogi, Thank you for all your wonderful advise...
  2. Conditional Formatting with Multiple Criteria in Excel Microsoft Excel has a limit of 3 criteria in Conditional...
  3. How to Create Heatmaps in Excel Starting with Excel 2007, a feature was added called “Color...

This entry was posted on Monday, February 23rd, 2009 at 8:42 pm and is filed under Excel Quick Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “Up and Down Trend Arrows for Scorecards in Excel”

  1. JP on February 26th, 2009 at 5:25 am

    I like to use the Wingdings font for this. The letter J is a smiley face, and the letter L is a frown. Wrap your calculation formula in an IF statement that returns the letter “J” if True, or the letter “L” if False.

    You could also use the REPT function to repeat a character a certain number of times inside a cell, creating a mini-chart.

  2. Joseph Harris on February 26th, 2009 at 7:02 am

    Great tips…Thanks…

  3. MP on August 5th, 2009 at 2:33 am

    Is there a way to use conditional formatting to change the trend from a “blank “, to “up arrow”, to “down arrow” and continue to repeat the non-ending cycle when ever the cell is “clicked” on?

    Thanks for any help…
    Mike

Leave a Reply

You must be logged in to post a comment.