shading rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Home>Styles>Conditional 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)
 
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
 
Peter

Re-read Bob's posting.

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


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

How do I alternate shading of rows, Excel 2007, no new tabs. 1
alternate row shading on filtered data 2
Cond. Formatting, Mod(Row) and cell conditions 2
shading rows in excel 10
How do I maintain alternate row shading after inserting a new row 4
formula for CF 5
alternate row shading kept with autofilter 3
Shade even rows in a sheet 2

Back
Top