Link to home
Create AccountLog in
Avatar of Sandesh555
Sandesh555Flag for India

asked on

Icon Set

How to use the Icon set in Conditional formatting( 3 Arrows (colored)?

It will apply cell by cell separtely,is it correct ?

if u know the solution give me the example please.. do the needful
Avatar of Arno Koster
Arno Koster
Flag of Netherlands image

1) select a number of cells containing values
2) apply formatting
3) the lowest third of the cells get a red arrow pointing downwards
    the middle third of the cells get a yellow arrow pointing right
    the highest third of the cells get a green arrow pointing upwards

so if you for example format cells with values ranging from 1 up to 9, all values <= 3 give the red arrow and all values >= 6 give a green arrow.
Here's the sample file.


sample.xlsx
ASKER CERTIFIED SOLUTION
Avatar of MINDSUPERB
MINDSUPERB
Flag of Kuwait image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Sandesh555

ASKER

Here i have added one sample file,

Here i want compare the previous year and current year. in the column B (current year) i want show the arrow

mark(increase or decrease or equal).. i tried it,

It will apply cell by cell separtely ,i could't do that entire B column (using applied for)  ?

.
icon-set.xlsx
I am not sure if the icon set can be used with your scenario. As what I know, it can be used only to format cells based on their values. Other experts might have solutions to meet on what you need.

If you are using Excel 2010, you may try to use the Sparkline. Here's the link on how to do it.

http://office.microsoft.com/en-us/excel-help/use-sparklines-to-show-data-trends-HA010354892.aspx?CTT=5&origin=HA010369709

Sincerely,
Ed
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks