Conditional formatting

[GordonLS]

Good morning. I need the following to fill right to the last populated cell in Row 1.
The range is correct working off E2, but my issue is that the conditional formatting stops at the last full populated column. In this case it is column P. Columns O and beyond are not completely populated.

'fill rows with color based off alternating order numbers

Range("a2", Range("a2").End(xlDown).End(xlToRight)).Select
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=MOD(SUMPRODUCT(--($e$2:$e2<>$e$1:$e1)),2)"
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorDark1
.TintAndShade = -0.14996795556505
End With

 

[Joe4]

See if this gives you what you want:

Dim lastRow as Long
Dim lastCol as Long
Dim rng as Range

lastRow = Cells(Rows.Count, "A").End(xlUp).Row
lastCol = Cells(1, Columns.Count).End(xlToLeft).Column

Set rng = Range(Cells(2, 1), Cells(lastRow, lastCol))

rng.FormatConditions.Add Type:=xlExpression, Formula1:= _
    "=MOD(SUMPRODUCT(--($e$2:$e2<>$e$1:$e1)),2)"
rng.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With rng.FormatConditions(1).Interior
    .PatternColorIndex = xlAutomatic
    .ThemeColor = xlThemeColorDark1
    .TintAndShade = -0.14996795556505
End With

 

[GordonLS]

Sorry for the delay Joe. Thanks for the solution.

 

[Joe4]

You are welcome.

 

[GordonLS]

Good evening. I need Column C be populated based off the following:

The sum of Column A and B need to be to populated in the last row of column C for the total of each Order Number in Column D.

In other words Column C6 will be the total of A2:B6. C7-C9 needs to be blank, so I'm thinking (iferror then blank). C10 will equal the sum of A10:B10. C11 will be blank and C17 should be the sum of A12:B17, etc.

 

[Joe4]

Good evening. I need Column C be populated based off the following:

The sum of Column A and B need to be to populated in the last row of column C for the total of each Order Number in Column D.

In other words Column C6 will be the total of A2:B6. C7-C9 needs to be blank, so I'm thinking (iferror then blank). C10 will equal the sum of A10:B10. C11 will be blank and C17 should be the sum of A12:B17, etc.

View attachment 59959

That is really a new question from your original, and should therefore be posted to a new thread.

 

[Joe4]

Why did you mark your new question as the solution?
You should only mark the post that contains the solution to your original question as the solution.
I have changed it back.

 

[GordonLS]

My mistake Joe.

 

[GordonLS]

Joe, do I now need to repost to a new thread?

 

[Joe4]

Joe, do I now need to repost to a new thread?

Yes, that is what I advised in my first response today:

That is really a new question from your original, and should therefore be posted to a new thread.