so if what i understand is correct, try this array formula:
=IF(MIN(MOD(ROW(INDIRECT(C1-2&":"&C1)),4)),"no","yes")

you have to paste the formula inside the formula bar & press CTRL + SHIFT + ENTER