JSECFHFNREELYL
New Member
- Joined
- Oct 24, 2011
- Messages
- 2
Hi - This is tricky and hopefully you can help as have yet to find out how to do this.
I have a spreadsheet with 185 rows and 100 columns. Each cell has a formula which will produce either a 1,2,3,4,5,6,7 or 8. The color of the cells are based on the number with red being the lowest (1) and green being the highest (8) - using conditional formatting. What I would like to do is add arrows to the cell based on the numbers, in addition to the colors - also using conditional formatting (or any other suggesstion). The odd numbers deserve a DOWN arrow and the even numbers deserve an UP arrow.
So to boil it down, 1 is Red and it scales to green at #8. The arrows should be up for even numbers and down for odd numbers.
Please Help!!
Thanks,
I have a spreadsheet with 185 rows and 100 columns. Each cell has a formula which will produce either a 1,2,3,4,5,6,7 or 8. The color of the cells are based on the number with red being the lowest (1) and green being the highest (8) - using conditional formatting. What I would like to do is add arrows to the cell based on the numbers, in addition to the colors - also using conditional formatting (or any other suggesstion). The odd numbers deserve a DOWN arrow and the even numbers deserve an UP arrow.
So to boil it down, 1 is Red and it scales to green at #8. The arrows should be up for even numbers and down for odd numbers.
Please Help!!
Thanks,