icon set 2010

[koi]

hi all,


just curious if there is another way to put the icon in right of cell, i know some people will go in B1 and put =A1 and put it there.. but i really like to know if in same cell.


also, is there any ways to put the formula to it? i fount put like =if not working for icon set


last one.. if you want to compare value from B1>A1 and using arrow icon, can you do it for range like apply for B1:B10? i found out that the cell ref must be absolute so even if you do it range.. the B10 always compare to A1


thanks all

 

[Hui]

Koi


Icon's can't be right or center aligned

What you can do is change the Alignment of the numbers in the cells

Select the cells with the icons

Ctrl 1

Alignment

Horizontal: Right (Indent)

Change the Indent Value, try 4

Apply


This will put the numbers right next to the icon, which will still be to the numbers left