Conditional Formatting - Icon Rule - Three Color Arrows

B

Baris

I am trying to do a chart as in below

'07 '08 '09
1 10 15 13
2 20 15 16
3 18 19 19

I am trying to use the Three Color Arrows for the changes from the previous
year.
I can format the individual cells one by one, however i am trying to use the
same formatting for whole columns. When I try to highlight the column it
doesnt work, (Green arrows display for an increased amout!) when i try to
copy and special paste the formatting it doesnt work either.

Please help me
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting and arrow icon sets 0
Calculating Work Time 7
Conditional formatting Icon Arrows 3
Conditional Formating with Icon set - How to change the color 3
Date Calculation & Conditional Formatting 3
Conditional Formatting 1
2007 conditional formatting not playing ball 5
Problems with Conditional Formatting in Excel 2007 0

Top