Conditional formatting only working on empty cells

[falcon771]

I have a worksheet where I have applied conditional formatting to color every other row.

Sheets("Dealer").Select
With Range("A1").CurrentRegion
.FormatConditions.Add Type:=xlExpression, Formula1:="=MOD(ROW(),2)=1"
.FormatConditions(1).Interior.ColorIndex = 15
End With

But for some reason, this is only coloring empty cells, not the entire row.

I have tried to use the menu option too, but I get the same results. I am using a new computer with Excel 2016 installed.

Thanks

 

[JumpingCrab]

Do you have another conditional format that overrides this one in the same region?

 

[falcon771]

Do you have another conditional format that overrides this one in the same region?

No, I even cleared out the existing rule and made sure there were no others. Still, the same result.

Oddly enough the exact same thing happens when I try to apply a Table Style. The same cells are not filled.

I am wondering if it is just a setting somewhere that I have missed.