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:

Date Received	Operator Name	Level 1 Process	Level 2 Process	Level 1 Error Type	Level 2 Error Type
8/7/2014	Smith, John	EP	CO	Mis-post	Copy/ Paste
8/7/2014	Smith, John	EP	CO	Mis-post	Copy/ Paste
8/7/2014	Smith, John	EP	CO	Mis-post	Account selection
8/11/2014	Smith, John	Data Entry	CO	Mis-post	Account selection
8/13/2014	Smith, John	EP	RSLV	Encoding	Mis-key
8/13/2014	Smith, John	EP	RSLV	Encoding	Mis-key
8/18/2014	Smith, John	Data Entry	CO	Mis-post	Copy/ Paste
8/21/2014	Smith, John	Data Entry	CO	Mis-post	Copy/ Paste
8/22/2014	Smith, John	EP	RSLV	Mis-post	Account selection
9/13/2014	Smith, John	EP	RSLV	Encoding	Mis-key
9/13/2014	Smith, John	EP	RSLV	Encoding	Mis-key
9/18/2014	Smith, John	Data Entry	CO	Mis-post	Copy/ Paste

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

 

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