I cannot seem to find a way on how to color 2 rows in a row. All tutorials are to color alternating rows.
Namely, this is the situation
A1:O1 Header Title A2:02 Header Subtitle A3:O3 Name A4:O4 Value A5:O5 Name A6:O6 Value A7:O7 Name A8:O8 Value ...
Title rows are colored manually.
I need to color rows 3 and 4 in 1 color, rows 5 and 6 in another color. Then again rows 7 and 8 in the first color. And so on.
Any ideas what custom formula in the conditional formatting should be?
I cannot use
unique formula as nothing is unique here.