Values to highest three scores...

  • Thread starter Thread starter Darry
  • Start date Start date
D

Darry

There is a ranking function within the math apps. You
could use it to put numbers om cells below. I have a more
complicated type app. I have 10 numbers which change.
They are located in a row. What I want to do is to change
forecolor on the top five cells, the sixth in a different
color and the last in a different color. Any ideas would
be appreciated.
 
No problem, assuming your data is in A1:A10, select the 10 values concerned and do Format /
Conditional formatting, Change cell value is to Formula is and put in:-

=RANK(A1,$A$1:$A$10)<6

Choose a font colour you like and hit OK, then hit Add

Put the following formula in:-

=RANK(A1,$A$1:$A$10)=6

Choose a font colour you like and hit OK, then hit Add

Put the following formula in:-

=RANK(A1,$A$1:$A$10)>6

Choose a font colour you like and hit OK, then hit Add
 
How do you rank from lowest to highest. The reverse of your earlier post?
 
Yep. Just change the signs or just change the colours, whichever gives you the result you want.
 
You must log in or register to reply here.

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

Highest score 3
Auto select highest 25 scores. 14
Finding location (or start cell) of highest consecutive values 3
Summing numbers dropping lowest and highest 2
Sum (throw out highest and lowest) 2
Need help on scoring 1
Get highest value and adjacent cell value 12
Top 4 scores in excel 4

Back
Top