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.

Date	Start	Finish
2/19/18	0730	0830
	0830	0900
	0900	0930
	0930	1200
	1230	1630
2/20/18	0730	0830
	0830	1100
	1100	1200
	1300	1330
	1330	1400
	1400	1430
	1430	1530
	1530	1630

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

 

[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.