Hi,

I have a Data sheet containing rows of employee data which i want to
color, if a specific condition is met & by the count of rows.

there is a small table which looks like :
------------
| 702 | ' it shows count of
the total no of rows.
-----------------------------------
| 10% | 74 | ' These show the
Breakup of total rows.
-----------------------------------
| 20% | 148 |
-----------------------------------
| 40% | 297 |
-----------------------------------
| 20% | 148 |
-----------------------------------
| 10% | 74 |
-----------------------------------
=========================
TOTAL: 100% | 702
=========================
Based on the breakup, i want to color the rows in different shades,
say, GREEN for top 10%, ORANGE for top 20%, YELLOW for middle 40%,
BROWN for lower 20% & lastly, GRAY for last 10%.

Also, in the last column, i want to automatically get a text say,

PLATINUM for top 10%,
DIAMOND for top 20%,
GOLD for middle 40%,
SILVER for top 20%,
BRONZE for top 10%,

How is it possible ????

Warm Regards,

..