Hi Sam,

In article ,
"Sam via OfficeKB.com" wrote:

Thank you very much - that worked Great.

You're very welcome!

I used this as the Conditional Formatting Formula Is:
=IF((ROWS(I$19:I19)<=ROWS(Position))*(MOD(ROW()-ROW(I$19)+0,3)=0),3,"")

Actually, this formula was intended for the second part in which you
want the number 3 in every 3rd cell. Enter it in cell I19 and copy
down. The first formula would suffice for Conditional Formatting.