Ms office question. - excel - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Ms office question. - excel

karaokecolin Avatar
5y, 11m agoPosted 5 years, 11 months ago
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.
Tags:
karaokecolin Avatar
5y, 11m agoPosted 5 years, 11 months ago
Options

All Comments

(3) Jump to unreadPost a comment
Comments/page:
#1
use the autoformat tool in the format menu
#2
Many thanks^^ I knew there was some easy way. doh.

col.
#3
Could have used conditional formatting, but meh.

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!