Conditional Formatting (3 Arrows)

[audrey]

Hello,

I have 2010 and 2011 rankings listed next to eachother, I want to use the 3 arrow conditinal formatting to reflect

if ranking hasnt changed use yelow
if ranking vs last changed use green
if ranking went down use red

can someone help me on this ?

 

[Desu Nota from Columbus]

That video is great! I've added around 20 abilities to my excel repertoire from watching their videos already!

 

[Akashwani]

I love watching the duelling podcasts.

Take a look here....
http://www.youtube.com/user/ExcelIsFun#g/u
Mike has over 1500 easy to follow videos.

Enjoy and get ready to impress your colleagues.

Ak