shade alternating rows in excel

[Matt8301]

how do i shade alternating rows in excel without going through one by one?
thanks

[JOn K via OfficeKB.com]

Matt8301 wrote:
>how do i shade alternating rows in excel without going through one by one?
>thanks
Conditional Formatting will take care of this problem

1) Select your data/range of cells

2) Format > Conditional Formatting

3) Condition 1 > Formula Is > =MOD(ROW(),2)=1, and choose you
formatting

4) Condition 2 > Formula Is > =MOD(ROW(),2)=0, and choose you
formatting
5) Click Ok


--
Message posted via http://www.officekb.com

[Paul B]

Matt, use conditional formatting



Select the range you want to format. Format > Conditional Formatting. In the
left dropdown, change ""Cell Value is"" to ""Formula Is"". In the formula
box type. =MOD(ROW(),2)=0 Click the ""Format..."" button. Click the
Patterns tab and pick a color.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Matt8301" <Matt8301@discussions.microsoft.com> wrote in message
news:848F82A4-F426-4316-946F-04630BB6CB56@microsoft.com...
> how do i shade alternating rows in excel without going through one by one?
> thanks

[behmen]

Hi, how would I shade every 4 rows in Excel? I tried =MOD(ROW(8),4)=1 but I'm getting a formula error message.
See desired result below. Thanks!

SHADE_ROWS.png

[popipipo]

Try this FO formula:

Please Login or Register  to view this content.

[behmen]

I'm still getting the formula error message. I also want to start the shading with Row 2, does the formula account for that?

Different question: I tried to remove the 2nd screenshot as it was not the cropped version of my workbook. How do I remove that from the post? I've tried "Edit Post > Go Advanced > Manage Attachments" but don't see the image or an option to remove.

[CK76]

Replace ";" with ",".

Edit: If starting from row 2. Just start your CF from row 2 (using same formula).

[behmen]

Perfect, yes! Thank you both!

[AliGW]

Behmen - in future, please do not hijack old threads. Instead, start your own. Thanks.

[behmen]

Ok, sorry, didn't know whether to add on to a subject or create a new one.

[AliGW]

You should have created a new one, but could have linked back to this thread. Too late now this time, but please remember for the future.

[Pete_UK]

And especially, don't hijack a thread which is 13 years old.

Pete