How do I set up conditional formatting in Excel 2007 to use Icon Sets
Posted on 2011-02-16
I'd like to use the arrows in the Icon Sets to indicate a higher or lower value in the previous cell in the row.
So, if A1 = 6, B1 = 8, C1 =6, I want B1 to show an up arrow and C2 would show a down arrow, etc.
I've tried the conditional formatting feature but I can't get past using the first cell as the reference cell for all cells.