Conditional graphbar colors [Closed]

Report
-
Hello,

I am trying to create a chart where column B depicts numbers for 2014 and Column c for 2015. 2014 is a line graph and 2015 is a bar graph, I wanted a formula where I can show that everytime value in 2015 is less than 2014 its green and everytime its over, it is red.
For ex week 1 in 2014 is 7 and week 1 in 2015 is 11, so the bar graph for 2015 will show red on top and green below; or if thats not possible, all red.

Hope that makes sense and an excel wiz can help me with this answer.

Thanks

Raj


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!