+ Reply to Thread
Results 1 to 5 of 5

Conditionally formatting rows

  1. #1
    junoon
    Guest

    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. #2
    junoon
    Guest

    Re: 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. #3
    junoon
    Guest

    Re: Conditionally formatting rows

    Can Anyone Help me with this??


  4. #4
    Richard Buttrey
    Guest

    Re: Conditionally formatting rows

    On 27 May 2006 07:30:28 -0700, "junoon" <[email protected]> wrote:

    >Can Anyone Help me with this??


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

    Rgds
    __
    Richard Buttrey
    Grappenhall, Cheshire, UK
    __________________________

  5. #5
    junoon
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1