Conditional Highlight two rows at a time

[wmtsub]

Similar to a table where it highlights every other row, I need to highlight two rows, then leave two blank and then highlight two etc - for the whole sheet. Any ideas?

 

[Joe4]

Use this Conditional Formatting formula:

=ISEVEN(INT((ROW()-1)/2))

 

[Eric W]

Select the columns you want to highlight. Click Conditional Formatting > New Rule > Use a formula > and enter:

=MOD(ROW()-1,4)>1

Click Format... and choose your fill color.

 

[wmtsub]

Thanks guys, sadly neither of these worked.

 

[Joe4]

Thanks guys, sadly neither of these worked.

They do, you must not be applying it correctly.

Follow these steps:
1. Select the entire range you want to apply this to
2. Go to Conditional Formatting
3. Select "New Rule"
4. Select "Use a formula to determine which cells to format"
5. Enter in the following formula:
=ISEVEN(INT((ROW()-1)/2))
6. Click the "Format" button, go to the Fill tab, and select your highlighting color
7. Click OK twice.

This will do the highlighting (2 rows on, 2 rows off, etc).