Conditional Formatting

F

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
 
M

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
 
S

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.
 
F

Freshman

Hi Max,

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

Best regards to you and your family.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top