Microsoft Excel - Automatically color alternating rows

http://Excelopedia.com presents a tutorial describing how to use Microsoft Excel's Conditional Formatting functionality so that alternate rows in a spreadsheet will be automatically formatted with a bacground color. Includes steps for both Excel 97-2003 and Excel 2007.

Category:

Howto & Style

Tags:

• microsoft
• excel
• office
• formatting
• howto
• tip
• trick
• tutorial
• 2007
• 2003
• 2000
• spreadsheet
• conditional
• excelopedia
• vista
• XP

[iamzero79]

You just saved me a lot of time. Thanks.

[kannoosh69]

Is it possible to generate a serial number in excel, in a single cell that is updated/rolled on, each time the form is used?

I have got it down to rolling on by 1 digit daily, by subtracting one date from another, but I can't figure out how to generate the number more than once a day.

Basically, this form will be used for dispatching goods out through stores.

Thanks in advance.

[MegaDecima]

Great explanation of the functions. Thanks.

[joaopnz]

Sorry, Me again. Run out of characters...

So, as you can see when using filter it does not work.

Anyway to solve this problem ?

Thank you very much

You have very helpful video !

[joaopnz]

Hi there. Wondering if you could help me. I used this video to help me to auto format. However I have a problem.... I have a Filter and with filter it does not work.Imagine this scenario ROw - Date Out - Qtd - Client 1 20Jan-10 - 100 - 1 2 24Jan-10 - 120 - 1 3 21Jan-10 - 110 - 2 4 27Jan-10 - 100 - 1 So when I use a filter by Cliente = 1 Would bring this 1 20Jan-10 - 100 - 1 2 24Jan-10 - 120 - 1 4 27Jan-10 - 100 - 1 On that case Row 2 and 4 would have the same color..

[nakan0]

I found out a way to make this work on Excel 2007. Not sure if it's a regional thing, but... try switching the coma to semi-colon in the formula. As in: =MOD(ROW();2) instead of =MOD(ROW(),2). Worked for me.

[stuifbergen]

For me it doesn't work eighter.

"The formula you typed contains an error"

I'm using MS Office Excel 2003 SP3.

[5tones]

i finaly got it to work but on an other comp. , on my pc it's still not working i guess i'll reinstall office

[5tones]

it's not working for me

it keeps telling me that the formula you typed contains an error

can someone please help me , i did it EXACTLY how you said , and it's stil not working

[alvin322]

superb!! well done!!