forecolor on groups changing based on values in cell

  • Thread starter Thread starter darry
  • Start date Start date
D

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???
 
Darry,

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

Eric
 
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
 
Back
Top