Ms office question. - excel

3 replies
Found 13th Feb 2011
Hi folks - I'm after a bit of advice with a quick question.

I am just about to print out an excel spreadsheet consisting of several hundred rows of data. It is basically a list of songs.

Is there a quick/easy way of alternating the colours of each row. eg 1st row green, 2nd blue, 3rd green, 4th blue and so on.

I know there is prob an easy answer to this but it's late and my head is on one.

I'm off in a mo so will convey any gratitude upon my return!
Cheers

Mr.c.

3 Comments

use the autoformat tool in the format menu

Original Poster

Many thanks^^ I knew there was some easy way. doh.

col.

Could have used conditional formatting, but meh.
Post a comment
Avatar
@
    Text
    Top Discussions
    1. 5 Letter Scrabble Game52522887
    2. Add one, leave one game54415468
    3. Just heard this...2 ★★★★★★★★★★★★★★ congrats to all on 392k ★★★★★★★★★★★★★★7769611
    4. US GrandPrix Razzmatazz78

    See more discussions