Hi All
I have a s/s where I work out the % dif between 2 cells (A1 & A2) and show that figure in A3. I would also like it to show an icon set (conditional formatting) on the cell as well as the figure but I cant seem to get it to show what i want
Basically if the figure is less than 0% then the red arrow should show, green if more than 0% and yellow if there is no change.
Thanks in advance
I have a s/s where I work out the % dif between 2 cells (A1 & A2) and show that figure in A3. I would also like it to show an icon set (conditional formatting) on the cell as well as the figure but I cant seem to get it to show what i want
Basically if the figure is less than 0% then the red arrow should show, green if more than 0% and yellow if there is no change.
Thanks in advance