This discussion is archived
9 Replies Latest reply: Sep 24, 2013 2:40 AM by Niv_D RSS

Conditional Format - to show top 5 values in different colors

Niv_D Newbie
Currently Being Moderated

Hi all ,

 

I have a requirement to show revenue of top 10 companies in colors.

 

In case there are 50 companies the companies having top 10 revenue ,(those columns) should be shown in different colors.

 

I am not exactly sure how to continue in conditional formatting in this.. Pls help

 

Reg,

Niv

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points