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
 
Yep. Just change the signs or just change the colours, whichever gives you the result you want.
 
Back
Top