Auto Coloring a Row

Discussion in 'Microsoft Excel Worksheet Functions' started by Guest, Jan 9, 2006.

  1. Guest

    Guest Guest

    Hey I have set up Excel with a Drop down option through-out Column G.

    If column G = 'Pass' I want that whole row to be Font.Color = Green
    If column G = 'Fail' I want the whole row to be Font.Color = Red

    How can I get this to occur automatically?

    I get all lost not knowing all the functions and parameters that excell uses.

    Please help me with this :)
     
    Guest, Jan 9, 2006
    #1
    1. Advertisements

  2. Guest

    SteveG Guest

    You can use Conditional Formatting.

    Select the entire row that you want to fill. Go to Format>Conditiona
    Formatting. Select the Formula is: Option and use this for formattin
    red.

    =$G3="Fail"

    Click on Format and select the color. Ok.

    Click Add>>

    For condition 2, use Formula Is

    =$G3="Pass"

    Click on Format and select the color. Ok.

    Click on Ok.

    Select the entire row again, click on the Format Painter and apply i
    to all the rows you need.


    Cheers,

    Stev

    --
    Steve
    -----------------------------------------------------------------------
    SteveG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=757
    View this thread: http://www.excelforum.com/showthread.php?threadid=49954
     
    SteveG, Jan 9, 2006
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    1) With A1 selected, Go into <Format><Conditional Formatting>
    2) Choose "Formula Is" in the drop down box and enter =$G1="Pass", and
    choose a green format
    3) Choose to add a condition (by pressing "Add>>"), choose "Formula Is" in
    the drop down box again, and enter =$G1="Fail", and choose a red format.
    4) Click OK
    5) Select A1 and copy the formatting across every column, and down every row
    you would like this formatting to occur.

    Does that help?
    --
    Regards,
    Dave


    "chhanson" wrote:

    > Hey I have set up Excel with a Drop down option through-out Column G.
    >
    > If column G = 'Pass' I want that whole row to be Font.Color = Green
    > If column G = 'Fail' I want the whole row to be Font.Color = Red
    >
    > How can I get this to occur automatically?
    >
    > I get all lost not knowing all the functions and parameters that excell uses.
    >
    > Please help me with this :)
     
    Guest, Jan 9, 2006
    #3
  4. Guest

    Guest Guest

    Hey guys none of this helped all that much :S

    The entire Column of "G" needs to have this rule applied for ALL rows.
    The code you guys gave me is per row capable only.

    Is there a wild card I can use? ex =$G*="Pass"

    or a way to apply the rule of Column "G" coloring each row to the whole
    worksheet?

    "David Billigmeier" wrote:

    > 1) With A1 selected, Go into <Format><Conditional Formatting>
    > 2) Choose "Formula Is" in the drop down box and enter =$G1="Pass", and
    > choose a green format
    > 3) Choose to add a condition (by pressing "Add>>"), choose "Formula Is" in
    > the drop down box again, and enter =$G1="Fail", and choose a red format.
    > 4) Click OK
    > 5) Select A1 and copy the formatting across every column, and down every row
    > you would like this formatting to occur.
    >
    > Does that help?
    > --
    > Regards,
    > Dave
    >
    >
    > "chhanson" wrote:
    >
    > > Hey I have set up Excel with a Drop down option through-out Column G.
    > >
    > > If column G = 'Pass' I want that whole row to be Font.Color = Green
    > > If column G = 'Fail' I want the whole row to be Font.Color = Red
    > >
    > > How can I get this to occur automatically?
    > >
    > > I get all lost not knowing all the functions and parameters that excell uses.
    > >
    > > Please help me with this :)
     
    Guest, Jan 10, 2006
    #4
  5. Guest

    SteveG Guest

    This should work. Using $G1 in your conditional format will allow you
    to drag the formula accross columns or vertically down rows keeping
    column G as the reference column and only changing the row number as it
    is copied down. Not sure without seeing an example of what you are
    trying to accomplish though.


    Steve


    --
    SteveG
    ------------------------------------------------------------------------
    SteveG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7571
    View this thread: http://www.excelforum.com/showthread.php?threadid=499544
     
    SteveG, Jan 10, 2006
    #5
  6. Guest

    Gord Dibben Guest

    "ALL" rows?

    CTRL + a(twice in 2003) to select every row of the sheet.

    Format>CF and enter the 2 conditions as you were shown.

    Make sure you use =$G1="Pass" for condition1 and =$G1="Fail" for
    condition2

    NOTE the $ sign to lock column G but not the row number.

    I think formatting the entire sheet is a bit much. Perhaps you could
    select cells A1:X500 or somesuch range.


    Gord Dibben MS Excel MVP


    On Tue, 10 Jan 2006 12:50:03 -0800, "chhanson"
    <> wrote:

    >Hey guys none of this helped all that much :S
    >
    >The entire Column of "G" needs to have this rule applied for ALL rows.
    >The code you guys gave me is per row capable only.
    >
    >Is there a wild card I can use? ex =$G*="Pass"
    >
    >or a way to apply the rule of Column "G" coloring each row to the whole
    >worksheet?
    >
    >"David Billigmeier" wrote:
    >
    >> 1) With A1 selected, Go into <Format><Conditional Formatting>
    >> 2) Choose "Formula Is" in the drop down box and enter =$G1="Pass", and
    >> choose a green format
    >> 3) Choose to add a condition (by pressing "Add>>"), choose "Formula Is" in
    >> the drop down box again, and enter =$G1="Fail", and choose a red format.
    >> 4) Click OK
    >> 5) Select A1 and copy the formatting across every column, and down every row
    >> you would like this formatting to occur.
    >>
    >> Does that help?
    >> --
    >> Regards,
    >> Dave
    >>
    >>
    >> "chhanson" wrote:
    >>
    >> > Hey I have set up Excel with a Drop down option through-out Column G.
    >> >
    >> > If column G = 'Pass' I want that whole row to be Font.Color = Green
    >> > If column G = 'Fail' I want the whole row to be Font.Color = Red
    >> >
    >> > How can I get this to occur automatically?
    >> >
    >> > I get all lost not knowing all the functions and parameters that excell uses.
    >> >
    >> > Please help me with this :)
     
    Gord Dibben, Jan 10, 2006
    #6
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. neeraj

    coloring rows based on criteria

    neeraj, Jul 4, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    679
    Bernard V Liengme
    Jul 4, 2003
  2. Kevin Timmons

    Coloring worksheet tabs

    Kevin Timmons, Jul 18, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    309
    Ken Wright
    Jul 18, 2003
  3. Roger Richter

    Coloring Tabs - How Do I

    Roger Richter, Aug 21, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    274
    Peo Sjoblom
    Aug 21, 2003
  4. Guest

    coloring every other row in a range

    Guest, Jun 11, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    246
    Guest
    Jun 11, 2005
  5. carusso

    Auto-update row numbers after inserting new row

    carusso, Jan 23, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    540
    Gord Dibben
    Jan 26, 2009
  6. arasan77

    Coloring the row and column numbering bars in Exce2003

    arasan77, Sep 4, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    314
    Kassie
    Sep 4, 2009
  7. arasan77

    Coloring the row and column numbering bars in Excel 2003â€

    arasan77, Sep 5, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    352
    bill kuunders
    Sep 5, 2009
  8. Lori Brooks

    I selected row 1 and row 2 to freeze and it is freezing at row 12

    Lori Brooks, Nov 17, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    421
    Mike H
    Nov 17, 2009
Loading...