Excel 2007 : Different colours in rows

[wisedave]

Hello,

Is there a way to have different colour rows similar to how you can set up Table Styles in Word?

I want to have each row alternate between 2 colours so it's easier to read.

Thanks for all the help!

-Dave

[NBVC]

You can use 2 conditional formatting rules.

=MOD(ROW(),2)=1

and

=MOD(ROW(),2)=0

each with its own colour.

[wisedave]

Hello NBVC,

In the two boxes, i want to alternate colours. Where do I put that coding?

Thanks for all the help!

Cheers,

Dave

[arthurbr]

Have a look at this page

Please don't quote posts unnecessarily. It makes the thread hard to read and clogs the posts. Thx

[arthurbr]

Wisedave, thank you for amending your post and marking solved