G Guest May 27, 2007 #1 Hi I am new to excel 2007 can anyone explain how you can shade alternate rows on mass thanks Pete
B Bob Phillips May 27, 2007 #2 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)
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)
G Guest May 27, 2007 #3 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
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
G Gord Dibben May 27, 2007 #4 Peter Re-read Bob's posting. He explains how to do it using Conditional Formatting as you want. Gord Dibben MS Excel MVP
Peter Re-read Bob's posting. He explains how to do it using Conditional Formatting as you want. Gord Dibben MS Excel MVP
