Highlight every 4th row within a month

[jenjamen]

Hello,

I am trying to conditionally format rows - every fourth row, but only if that row happened in the same month. I have not been able to get a countif or index formula to work in the conditional format rule field. I am using XL2007.

Thanks in advance!
jennifer

Here's what I would like it to look like:
[TABLE="width: 797"]
<tbody>[TR]
[TD]Date Received[/TD]
[TD]Operator Name[/TD]
[TD]Level 1 Process[/TD]
[TD]Level 2 Process[/TD]
[TD]Level 1 Error Type[/TD]
[TD]Level 2 Error Type[/TD]
[/TR]
[TR]
[TD]8/7/2014[/TD]
[TD]Smith, John[/TD]
[TD]EP[/TD]
[TD]CO[/TD]
[TD]Mis-post[/TD]
[TD]Copy/ Paste[/TD]
[/TR]
[TR]
[TD]8/7/2014[/TD]
[TD]Smith, John[/TD]
[TD]EP[/TD]
[TD]CO[/TD]
[TD]Mis-post[/TD]
[TD]Copy/ Paste[/TD]
[/TR]
[TR]
[TD]8/7/2014[/TD]
[TD]Smith, John[/TD]
[TD]EP[/TD]
[TD]CO[/TD]
[TD]Mis-post[/TD]
[TD]Account selection[/TD]
[/TR]
[TR]
[TD]8/11/2014[/TD]
[TD]Smith, John[/TD]
[TD]Data Entry[/TD]
[TD]CO[/TD]
[TD]Mis-post[/TD]
[TD]Account selection[/TD]
[/TR]
[TR]
[TD]8/13/2014[/TD]
[TD]Smith, John[/TD]
[TD]EP[/TD]
[TD]RSLV[/TD]
[TD]Encoding[/TD]
[TD]Mis-key[/TD]
[/TR]
[TR]
[TD]8/13/2014[/TD]
[TD]Smith, John[/TD]
[TD]EP[/TD]
[TD]RSLV[/TD]
[TD]Encoding[/TD]
[TD]Mis-key[/TD]
[/TR]
[TR]
[TD]8/18/2014[/TD]
[TD]Smith, John[/TD]
[TD]Data Entry[/TD]
[TD]CO[/TD]
[TD]Mis-post[/TD]
[TD]Copy/ Paste[/TD]
[/TR]
[TR]
[TD]8/21/2014[/TD]
[TD]Smith, John[/TD]
[TD]Data Entry[/TD]
[TD]CO[/TD]
[TD]Mis-post[/TD]
[TD]Copy/ Paste[/TD]
[/TR]
[TR]
[TD]8/22/2014[/TD]
[TD]Smith, John[/TD]
[TD]EP[/TD]
[TD]RSLV[/TD]
[TD]Mis-post[/TD]
[TD]Account selection[/TD]
[/TR]
[TR]
[TD]9/13/2014[/TD]
[TD]Smith, John[/TD]
[TD]EP[/TD]
[TD]RSLV[/TD]
[TD]Encoding[/TD]
[TD]Mis-key[/TD]
[/TR]
[TR]
[TD]9/13/2014[/TD]
[TD]Smith, John[/TD]
[TD]EP[/TD]
[TD]RSLV[/TD]
[TD]Encoding[/TD]
[TD]Mis-key[/TD]
[/TR]
[TR]
[TD]9/18/2014[/TD]
[TD]Smith, John[/TD]
[TD]Data Entry[/TD]
[TD]CO[/TD]
[TD]Mis-post[/TD]
[TD]Copy/ Paste[/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"><col span="2"></colgroup>[/TABLE]

 

[Scott Huish]

Assuming that table starts at A1, try this formula in Conditional Formatting:

=AND(MOD(ROW($A1)-1,4)=0,MONTH($A1)=MONTH(TODAY()))

 

[jenjamen]

Thank you so much!! That worked perfectly.