Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    May 2004
    Location
    Marshall, Minnesota, USA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional formatting (2002)

    I am applying conditional formatting to an entire column. Is there a way to apply conditional formatting to an entire row of information based on criteria in one column?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional formatting (2002)

    Welcome to the Lounge!

    Yes, you can. Select the row, then select Format | Conditional Formatting...
    From the dropdown list, select Formula Is.
    In the box next to it, enter a formula such as this:

    =($F1 > 100)

    where F1 is the cell you want to test. (I have assumed row 1 for this example). Click Format to specify the formatting to be applied, then click OK twice. The $ before F means that this column is fixed; if you omit it, the formula will be adjusted for other cells.

  3. #3
    New Lounger
    Join Date
    May 2004
    Location
    Marshall, Minnesota, USA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting (2002)

    Thanks for replying so quickly. I tried this but it did not work. I am sending the file that I am using. What I want to do is apply conditional formatting to column F to highlight what is behind schedule and have the formatting applied to the entire row.

  4. #4
    Lounger
    Join Date
    Feb 2004
    Location
    Buffalo, New York, Wales
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting (2002)

    In conditional formatting use Cell value is / equal to / Behind
    and click ok.

    If you want to be sure it works place it in a cell which has Behind in it.

    To copy this to other cells (those you want in column F) click on the cell you placed the conditional formatting in, copy, then select the cells you wish the formatting to go into and select paste special / formats. That should do it.

    yoyophil

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional formatting (2002)

    YOu need to put parentheses around Behind.
    Select A4:E28
    Format - cond format
    Formula is:
    <pre>=($F4="Behind")</pre>


    Steve

  6. #6
    New Lounger
    Join Date
    May 2004
    Location
    Endicott, New York, USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting (2002)

    Thanks for this method - I have been trying to figure out a way to do this for years (literally!), and this worked beautifully for me.

    Michelle

Posting Permissions

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