Conditional format to color alternating rows

[GordonLS]

Good morning, this fills rows with color based off alternating order numbers in column E. The issuse is that it does not fill across all the columns on the sheet. Not all cells are populated in all columns.

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


End Sub

 

[Joe4]

The way you have written your code is very dependent upon your data structure, which you have not shown us.
Please show us a sample of what your data looks like, and what you want your expected result to look like.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[GordonLS]

Thank you. I will work on this.