Hi, I want to format a sheet to show on each every 5 rows to a different
color, i.e. R5, R10,R15.....,R150,R155 all in yellow and the rest are in
normal white.
How can I do that?
Thank you.
GL

try this as the formula in conditional format - result will be zer
every 5th row

=MOD(ROW(),5)=

--
duan

-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=27806

Hi GL,

Select the region you want this applied to (possibly the entire sheet in
your case) and then go to Format | Conditional Formatting... | select
"Formula Is" and then put for the formula: =MOD(ROW(), 5)=0

Then click the "Format..." button and select yellow color under the Pattern
tab.

I can show you how to do it in VBA if you want, but this is probably easier.

-Erik

"G Lam" wrote in message
...
Hi, I want to format a sheet to show on each every 5 rows to a different
color, i.e. R5, R10,R15.....,R150,R155 all in yellow and the rest are in
normal white.
How can I do that?
Thank you.
GL

Euane and Erik,

I did write the openbook event in VBA to get the same result, but this is a
lot easer and faster.
Thank you.

GL

"Erik Oveson [MSFT]" ¦b¶l¥ó
¤¤¼¶¼g...
Hi GL,

Select the region you want this applied to (possibly the entire sheet in
your case) and then go to Format | Conditional Formatting... | select
"Formula Is" and then put for the formula: =MOD(ROW(), 5)=0

Then click the "Format..." button and select yellow color under the
Pattern
tab.

I can show you how to do it in VBA if you want, but this is probably
easier.

-Erik

"G Lam" wrote in message
...
Hi, I want to format a sheet to show on each every 5 rows to a different
color, i.e. R5, R10,R15.....,R150,R155 all in yellow and the rest are in
normal white.
How can I do that?
Thank you.
GL