Dear experts,

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.

Thanks in advance

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.

Hi Max,

You are great and the mentod works wonderful. Thanks again.

Best regards to you and your family.

"Max" wrote:

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.

Welcome, glad it helped
Thanks for the thoughts
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"Freshman" wrote in message
...
Hi Max,

You are great and the mentod works wonderful. Thanks again.

Best regards to you and your family.

Hi,

Highlight all the cells A1:A500,
Choose Format, Conditional Formatting, from the first drop down pick Formula
is, in the second drop down enter the formula
=MOD($A1,14)=0
Click the Format button to the right and select the Patterns tab, pick a
blue, click OK twice.

--
Thanks,
Shane Devenshire


"Freshman" wrote:

Dear experts,

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.

Thanks in advance

Hi Shane,

Thanks for your tip and it works wonderful. Thanks again.

Best regards.

"ShaneDevenshire" wrote:

Hi,

Highlight all the cells A1:A500,
Choose Format, Conditional Formatting, from the first drop down pick Formula
is, in the second drop down enter the formula
=MOD($A1,14)=0
Click the Format button to the right and select the Patterns tab, pick a
blue, click OK twice.

--
Thanks,
Shane Devenshire


"Freshman" wrote:

Dear experts,

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.

Thanks in advance