Alternate table row colours not changing in one column
Results 1 to 7 of 7

Thread: Alternate table row colours not changing in one column
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2018
    Location
    NSW, Australia
    Posts
    869
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Alternate table row colours not changing in one column

    I have a table in a sheet where I enter information for quotes. I have uploaded my spreadsheet. Open it and press the button "Send to costing tool" that is on the sheet "npss_quote_sheet" about 4 or 5 times. It should paste the row on the first sheet to a table on the sheet "Costing_tool with different colours for alternate rows as what normally happens for a table. All the rows have alternate colours except cells in column F. Can someone tell me how I fix it so it looks like a normal table please?

    https://drive.google.com/file/d/1q5b...ew?usp=sharing

    Thanks,
    Dave

  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,691
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Alternate table row colours not changing in one column

    Try

    Code:
    Sub MM1()
    Dim r As Long
    For r = 6 To Range("A" & Rows.Count).End(xlUp).Row Step 2
        Rows(r).EntireRow.Interior.ColorIndex = 2
    Next r
    End Sub
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  3. #3
    Board Regular
    Join Date
    Mar 2013
    Posts
    761
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Alternate table row colours not changing in one column

    Before clicking the "Send to costing tool" button,
    try Selecting F5 on Costing_tool and formatting the fill as No Color.
    Last edited by NoSparks; Aug 23rd, 2019 at 01:00 AM.

  4. #4
    Board Regular
    Join Date
    Aug 2018
    Location
    NSW, Australia
    Posts
    869
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Alternate table row colours not changing in one column

    I fixed the problem. Selected a cell in tblCosting that had the correct formatting, hit format painter and then selected the cell with the formatting issue.

  5. #5
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,691
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Alternate table row colours not changing in one column

    Yeah, but do you want to do that every time ???
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  6. #6
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,456
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    19 Thread(s)

    Default Re: Alternate table row colours not changing in one column

    Quote Originally Posted by Michael M View Post
    Yeah, but do you want to do that every time ???
    Doesn't need to. It is a table so the rows automatically get the colour banding now that the rogue formatting in that one cell (F2) has been corrected.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  7. #7
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,691
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Alternate table row colours not changing in one column

    Doh !.....Of course, Thank you.
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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