Custom Format to get red & green arrows in Excel cells
[Color10]_(0.00* "▲"_);[Red]_(-0.00* "▼"_)
where Color10 = Green color
If * is removed from 0.00 then numbers & arrows comes near to each other
For % with arrows use below custom format
[Color10]_(0.00%* "▲"_);[Red]_(-0.00%* "▼"_)
Here also, if you remove * the arrows & numbers comes near each other
[Color10]_(0.00* "▲"_);[Red]_(-0.00* "▼"_)
where Color10 = Green color
If * is removed from 0.00 then numbers & arrows comes near to each other
For % with arrows use below custom format
[Color10]_(0.00%* "▲"_);[Red]_(-0.00%* "▼"_)
Here also, if you remove * the arrows & numbers comes near each other