Conditional Formatting

[Freshman]

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

 

[Max]

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

 

[ShaneDevenshire]

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.

 

[Freshman]

Hi Max,

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

Best regards to you and your family.

 

[Freshman]

Hi Shane,

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

Best regards.

 

[Max]

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