VBA Help - =MOD(ROW()

[Doogles10]

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

[HaHoBe]

Hi, Dougie,

maybe like this:

Please Login or Register  to view this content.

where you maybe would need to adjust the number of columns to fill as well as the column which hold s the constant data.

Ciao,
Holger