Values to highest three scores...

[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.

 

[Ken Wright]

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

 

[namelocbob]

How do you rank from lowest to highest. The reverse of your earlier post?

 

[Ken Wright]

Yep. Just change the signs or just change the colours, whichever gives you the result you want.