forecolor on groups changing based on values in cell

[darry]

I have a group of ten cells in a row. I want to change
forecolor on top 5 cell values to one color, the 6th to a
different color and the last four to a separate color.
Values in cells will change and want colors to change with
values. Does anyone know how to do this???

 

[Eric]

Darry,

Check out the uses of "Conditional Formatting" from the
Format menu in Excel. Sounds like it will do the trick
for you.

Eric

 

[Ken Wright]

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