Hello,
I hope you could help me with the following issue. I would like to use conditional formatting to mark cells with arrows depending on the difference between the values in those cells and figures from different cells.
Namely, I have percentage values in column A and B. I need cells in column B to be marked with arrows (up, right or down) when the difference between value B and A is bigger than 2%, bigger than 0 but smaller than 2%, and smaller than 0 respectively (pls see the spreadsheet attached).
I spent some time searching for a solution to this issue but I couldn't find anything that would help me sufficiently...
Thanks in advance for your support on this!
Conditional Formating.xls
Bookmarks