Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally formatting rows
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, .. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally formatting rows
Sorry,
typo mistake...... PLATINUM for top 10%, DIAMOND for top 20%, GOLD for middle 40%, SILVER for bottom 20%, BRONZE for bottom 10%, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally formatting rows
Can Anyone Help me with this??
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally formatting rows
On 27 May 2006 07:30:28 -0700, "junoon" wrote:
Can Anyone Help me with this?? conditionally format a cell and copy as appropriate perhaps????? Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally formatting rows
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
REALLY miussing rows in Excel2000 | Excel Discussion (Misc queries) | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) |