Alternate table row colours not changing in one column

[dpaton05]

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/1q5bXhu_oMaax7MGQuMGCOUB_N18_IOH5/view?usp=sharing

Thanks,
Dave

 

[Michael M]

Try

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

 

[NoSparks]

Before clicking the "Send to costing tool" button,
try Selecting F5 on Costing_tool and formatting the fill as No Color.

 

[dpaton05]

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.

 

[Michael M]

Yeah, but do you want to do that every time ???

 

[Peter_SSs]

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.

 

[Michael M]

Doh !.....Of course, Thank you.