I am trying to highlight blocks of 3 rows so I have been using the following formula:
=MOD(CEILING(ROW(),5),2)=1
I want it to start in row 2 though, so the following happens:
Row 1 = Blank
Row 2,3,4 = Fill
Row 5,6,7 = Blank
etc
I have tried only highlighting the range that I want to fill but it still starts in row 1.
Does anyone know how to do this?
Bookmarks