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:
the conditional formatting is set as “equal to =”t”" set to green bold, “equal to =”u”" set to red bold.
Joseph Harris
Excel Help
Related posts:
- Conditional Formatting Q: Dear ExcelYogi, Thank you for all your wonderful advise...
- Conditional Formatting with Multiple Criteria in Excel Microsoft Excel has a limit of 3 criteria in Conditional...
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.
Great tips…Thanks…
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