Hi all,

I was given the following conditional formatting formula to help me shade 3 rows, leave 3, shade 3 etc (starting at row 2):

=MOD(CEILING(ROW()-1,3),2)

This works exactly how I want it to, but I'm using it on Excel 2003 and there are cells which already have 3 conditional formats so I can't add this conditional format.

Is there a way to do the same thing but using VBA instead so I can keep my other 3 conditional formats?

Cheers,

Dougie