Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Somewhere Over the Rainbow
    Posts
    232
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hello,

    In my spreadsheet I formatted every other row to be filled in Blue and white.
    When I insert a new row it throws off my Blue / white stripe sequence.

    For Example:
    Before Inserted Row:

    Blue
    White
    Blue
    White
    Blue

    After Inserted Row:

    Blue
    White
    Blue
    Blue
    White
    Blue

    Please let me know if there is a way to make Excel fix this. Thanks.
    Time can fix anything.....even a broken clock. - Handy Andy

  2. #2
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts
    try this

    1) Select the area in which you wish to highlight
    2) Go to the Format menu and select Conditional Formatting.
    3) In Condition 1, select "Formula Is"
    4) Next to it, type in "=MOD(ROW(),2)=1"
    5) Click on the Format >> Patterns tab.
    6) Select the color you want
    7) OK >> OK

    The area you selected should have every other row showing color you have selected
    If you add or delete a row, the shading remains consistent

    The attached shows what you are after
    Attached Files Attached Files
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  3. #3
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Somewhere Over the Rainbow
    Posts
    232
    Thanks
    0
    Thanked 1 Time in 1 Post
    Maybe I need a little help understanding your directions.
    Your attached file is exactly what I want, but I can't seem to get this to work on my file.
    Thanks very much,
    HandyAndy

    [quote name='franciz' post='775586' date='17-May-2009 14:06']try this

    1) Select the area in which you wish to highlight
    2) Go to the Format menu and select Conditional Formatting.
    3) In Condition 1, select "Formula Is"
    4) Next to it, type in "=MOD(ROW(),2)=1"
    5) Click on the Format >> Patterns tab.
    6) Select the color you want
    7) OK >> OK

    The area you selected should have every other row showing color you have selected
    If you add or delete a row, the shading remains consistent

    The attached shows what you are after[/quote]
    Time can fix anything.....even a broken clock. - Handy Andy

  4. #4
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HandyAndy' post='775588' date='18-May-2009 02:22']Maybe I need a little help understanding your directions.
    Your attached file is exactly what I want, but I can't seem to get this to work on my file.
    Thanks very much,
    HandyAndy[/quote]


    At which part of the above you are not sure of?
    or you can use the attachment I have provided

    Open the attachment
    Select the area highlighted
    Go to the Menu bar
    Select Format, then choose Conditional Formatting

    from there, you will see how the formatting can be done.

    Let me know if you still can't get it.
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  5. #5
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Somewhere Over the Rainbow
    Posts
    232
    Thanks
    0
    Thanked 1 Time in 1 Post
    Nevermind, I got it to work, Thanks.
    I forgot to first remove the coloring I had on the cells.


    [quote name='HandyAndy' post='775588' date='17-May-2009 14:22']Maybe I need a little help understanding your directions.
    Your attached file is exactly what I want, but I can't seem to get this to work on my file.
    Thanks very much,
    HandyAndy[/quote]
    Time can fix anything.....even a broken clock. - Handy Andy

Posting Permissions

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