Shading Columns with Conditional Formatting

Hello

What formula do I need to use to automatically colour blocks of columns x 4 across.
So for example colour columns A to D in yellow, then E to H with no fill, then I to L in yellow and so on?

Thanks
Debbie

select a1 to say p500
conditional format as
=MOD(CEILING(COLUMN(A1),4)/4,2)=1 pick a colour
this will do 1-4 9-12
if you want 5-8 13-16
=MOD(CEILING(COLUMN(A1),4)/4,2)=0
only do the range you need or you may end up with "too many formats" error messages sometime in the future