Forum Discussion

mfearn's avatar
mfearn
Copper Contributor
Jan 17, 2025

Formatting custom numbers in excel

Hi - if I am formatting custom numbers in excel to show up and down arrow trends, using format cells>number>custom>type

[Color10] 0% ↑;[Red]  0% ↓;

 

This shows me the difference between cells and if there is an increase, I get an up arrow in green.

Is there a way of showing when there is no difference, so I get an = sign in the cell, rather than a blank cell please?

 

Thanks

 

Resources