Results 1 to 6 of 6
  1. #1
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts

    Apply format alternately (2003)

    Aside from using a function or macro as desceibed in other posts, is there a quick way to apply background shading to alternate rows in my spreadsheet? Thanks.
    JimmyW
    Helena, MT

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Apply format alternately (2003)

    Hi Jimmy

    Have a look here:


    <!post=Shading alternate rows ,418977>Shading alternate rows <!/post>
    Jerry

  3. #3
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts

    Re: Apply format alternately (2003)

    Thanks very much, Jerry. I tried the method, but something went wrong. I selected a2..h428. In Conditional format, I entered Formula is =mod(row(),2)=0. I chose a blue background, which was applied to 2,4,6,8, etc. Except for a262..h318, all of which are blue (there are 56 consecutive blue rows). To be clear, a1..h1 is white, a2..h2 is blue, and I wanted to alternate white/blue the rest of the way. My desired formatting resumes after h318.
    JimmyW
    Helena, MT

  4. #4
    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: Apply format alternately (2003)

    I can not duplicate the problem. Could you attach your problem spreadsheet (you can delete the other sheets and even remove any data on the sheet) we only need the cond formatting...

    Steve

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

    Re: Apply format alternately (2003)

    Select A2:H428, then select 'No fill' from the fill color dropdown on the Formatting toolbar (or specify 'No color' in the Pattern tab of Format | Cells...).

  6. #6
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts

    Re: Apply format alternately (2003)

    Problem solved! I had an in place filter in effect when I used Jerry's suggestion. Removing the filter solved the issue. My fault. Sorry for the confusion, and thanks to all for helping!
    JimmyW
    Helena, MT

Posting Permissions

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