Forum Discussion
Excel functions for column compares
I'm new to Excel and want to find a function that compares one column to another and if the value goes up sends me an indication (trend up) and if the value goes down (trend down). For example ...
You can add a helper column that calculates the difference:
Use this to create a conditional formatting rule of type Icon Sets.
If you wish, you can hide the numbers by ticking the check box "Show Icon Only".