Conditional Formatting Question

[JoshYoung81]

Given the Cell set in columns A to C, I want each of the first 5 rows to be shaded and the next 8 not to be (or shaded differently), and so on, alternating by date.
[TABLE="width: 181"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Start[/TD]
[TD]Finish[/TD]
[/TR]
[TR]
[TD="align: right"]2/19/18[/TD]
[TD]0730[/TD]
[TD]0830[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]0830[/TD]
[TD]0900[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]0900[/TD]
[TD]0930[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]0930[/TD]
[TD]1200[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1230[/TD]
[TD]1630[/TD]
[/TR]
[TR]
[TD="align: right"]2/20/18[/TD]
[TD]0730[/TD]
[TD]0830[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]0830[/TD]
[TD]1100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1100[/TD]
[TD]1200[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1300[/TD]
[TD]1330[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1330[/TD]
[TD]1400[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1400[/TD]
[TD]1430[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1430[/TD]
[TD]1530[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1530[/TD]
[TD]1630[/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Select the columns you want to shade, say A:C. Then click Conditional Formatting > New Rule > Use a formula > and enter:

=MOD(COUNTIF($A$1:$A1,">0"),2)

click Format and choose a fill color.

 

[JoshYoung81]

Thats perfect, thanks.

 

[Eric W]

You're welcome.