Excel 2007 : Applying shading to every second row

**DrummeR-** · 05-09-2010, 07:58 AM

I'm wondering if theres a way to add shading to every second row on the worksheet, even if I insert new rows into the worksheet.

Mainly because it's a sheet going from A to P and I want to graphically seperate each entry.

Thanks!

**pike** · 05-09-2010, 08:09 AM

Hi DrummeR-
One way
Select the area
then in conditional Formatting
=Mod(row(),2=0
select format shading

**DrummeR-** · 05-09-2010, 08:53 AM

Where do I go to add that code exactly? (After hitting conditional formatting)

**pike** · 05-09-2010, 09:07 AM

Hi DrummeR-
in the formula area
select conditional Formatting in the help
it has a good explaination

**martindwilson** · 05-09-2010, 09:08 AM

use the "use a formula to determine option" in conditional formatting

**DrummeR-** · 05-09-2010, 07:46 PM

\1

That doesn't do anything.

**martindwilson** · 05-09-2010, 08:22 PM

typo
try
=MOD(ROW(),2)=0
dont forget to select the range you want shaded or it will only do the cell you are in

**DrummeR-** · 05-09-2010, 08:38 PM

Thanks..

**teylyn** · 05-09-2010, 08:43 PM

DrummeR,

why not simply click Format as Table on the Home ribbon? This will give you several format and coloring options, which will then also be applied to new rows.

cheers