Conditionally formatting rows

[junoon]

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,

..

 

[junoon]

Sorry,

typo mistake......

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

 

[junoon]

Can Anyone Help me with this??

 

[Richard Buttrey]

Can Anyone Help me with this??

conditionally format a cell and copy as appropriate perhaps?????

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[junoon]

Hi Richard,

You can conditional format upto 3 conditions & i have 5. Does not work
& i need to color the rows as per the numbers in the table.

Warm regards,

Junoon