First let's do this quick tinker ..
Put in any row1 cell, say in B1: =MOD(ROW(),14)
Copy down to B28. You'd see that it returns a repeating series: 1,2,3,..13,0
where the zeros are exactly at the rows 14, 28, etc that you want CF'd
(Clear col B)

To effect the CF, just select the row headers for row 1-500,
then apply the CF using Formula Is: =MOD(ROW(),14)=0
Format it to taste (blue fill), ok out
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"Freshman" wrote:
I have account numbers in column A and I would like the account numbers in
rows 14, 28, 42..... (i.e. the multiples of 14) up to row number 500 are
highlighted in colour blue background. Is there a way to do this? If yes,
how? Please kindly advise.