Different coloured rows

[The Stoat]

Hi all,

Does anyone know how to automatically make one row white background, next
row light grey (to make reading across the row easier) and alternate all the
way down the page?

Thanks for any help.

Matt.

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/banding.htm
for using conditional format to achieve this

 

[JE McGimpsey]

take a look here:

http://cpearson.com/excel/banding.htm

 

[Dave Hawley]

Hi Matt

Select your table range and then go to Format>Conditional Formatting.
Choose "Formula is" and then enter

=MOD(ROW(),2)

Now click format and choose your format choice.

*****Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum & Business Software*****

 

[The Stoat]

Thanks all!