Forum Discussion
mfearn
Jan 17, 2025Copper Contributor
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
Try
[Color10] 0% ↑;[Red] 0% ↓;=
- mfearnCopper Contributor
Thank you - that's exactly what I needed. Much appreciated.
Try
[Color10] 0% ↑;[Red] 0% ↓;=