Does anyone know how to make or calculate the “% Δ” columns? with the colored arrows
Hi,
I am able to get similar (but not exact) results by creating a custom Display Format (to add the symbols) and then applying conditional formatting (to add the colour).
To enter the ▲and ▼ symbols I press Windows Key + . (Period) to bring up the emoji selector. Then went to Symbols - Geometric symbols to locate them.
Then added conditional formatting - one rule to say anything above zero should be in green, another to say anything below zero should be red.