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