modify every other row with an and condition

[aggie24193]

I am trying to modify every other row in a spreadsheet.
I used to just have baseline schedule highlighted on each row with the following formula:
=AND(D$4<=LookUpValues!$H2, D$4>=LookUpValues!$D2)

But now I have added a row in between called actual where I am putting my actual schedule and I do not know how to make the condition apply to every other row.

I have tried using the MOD(ROW()) command but keep getting errors. Any help would be greatly appreciated.

 

[aggie24193]

I am basing my condition on values from a different sheet in the same workbook. Just to expand a bit more

 

[FDibbins]

Maybe add an extra rule in your AND that says something like...
=AND(D$4<>"Actual",D$4<=LookUpValues!$H2, D$4>=LookUpValues!$D2)