Custom Formatting
Excel Tips and Tricks

Arrows Symbols (➷➹) with Custom Formatting in Excel

Custom formatting is very useful in Excel. You can display some Icon with colors with the numbers. Here we have taken an example wherein we have displayed designer up/down arrow (➷➹) for Variance %.

We have a table for Market wise sales for Current Year and Previous Year. We have displayed Variance % here with designer arrows.

Market Wise Data
Market Wise Data

In the Variance % column we have used below given Custom Formatting.

[Color10]”➹     “0%;[Red]”➷     “0%;[Color45]”⇔     “0%

Custom Formatting
Custom Formatting

 

Click here to download the practice file.

 

Watch the step by step video tutorial:

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com