Hi I am new to excel 2007 can anyone explain how you can shade alternate rows
on mass

thanks

Pete

Just select the rows to be shaded.

Goto HomeStylesConditional Formatting

Select New Rule

Select Use a formula to determine which cells to format

In the editbox, enter =MOD(ROW(),2)=0

Click Format and select the Fill tab

Select a colour and OK out

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"peter mizzi" wrote in message
...
Hi I am new to excel 2007 can anyone explain how you can shade alternate
rows
on mass

thanks

Pete

thanks for this but there is a way somehow you can do it in conditional
formating and this what iam trying to work out, i think i have found a
forumla but cant work out where to put it .....someone please help

"Bob Phillips" wrote:

Just select the rows to be shaded.

Goto HomeStylesConditional Formatting

Select New Rule

Select Use a formula to determine which cells to format

In the editbox, enter =MOD(ROW(),2)=0

Click Format and select the Fill tab

Select a colour and OK out

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"peter mizzi" wrote in message
...
Hi I am new to excel 2007 can anyone explain how you can shade alternate
rows
on mass

thanks

Pete

Peter

Re-read Bob's posting.

He explains how to do it using Conditional Formatting as you want.


Gord Dibben MS Excel MVP

On Sun, 27 May 2007 06:33:01 -0700, peter mizzi
wrote:

thanks for this but there is a way somehow you can do it in conditional
formating and this what iam trying to work out, i think i have found a
forumla but cant work out where to put it .....someone please help

"Bob Phillips" wrote:

Just select the rows to be shaded.

Goto HomeStylesConditional Formatting

Select New Rule

Select Use a formula to determine which cells to format

In the editbox, enter =MOD(ROW(),2)=0

Click Format and select the Fill tab

Select a colour and OK out

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"peter mizzi" wrote in message
...
Hi I am new to excel 2007 can anyone explain how you can shade alternate
rows
on mass

thanks

Pete