Microsoft Excel - Automatically color alternating rows

[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..

[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

[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.

[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

[stuifbergen]

For me it doesn't work eighter.

"The formula you typed contains an error"

I'm using MS Office Excel 2003 SP3.

[alvin322]

it's very good. but how can i add two colors?

[isntrocketsurgery]

condition 1 (formula):

=mod(row(),2)=0  [color 1]

condition 2 (formula):

=mod(row(),2)=1 [color 2]

You could also do 3 colors with mod(xx,3)

[alvin322]

superb!! well done!!

[clevelandrox07]

i just got out of the shower and im still naked xD T

[salongirl77]

That was excellent thank you :)

[DannyRocksExcels]

Very nicely done! I especially liked your explanation of the =MOD() portion of the formula.

Danny

[itsmesajjad]

LOve U dude for this useful info....

[leemboo7]

Cheers mate!

[jmonn01]

I tried this and it doesn't seem to work.

[craigopher]

Hundreds of people have used this method. Can you be more specific as to where it is going wrong? Perhaps the instructions need better clarification at some point?

[jmonn01]

Thanks for the reply. I got it to work. I wish i knew about it before I manually deleted 100s of rows.

[stenionet]

I was looking for this. Very useful. Thank you very much.

[kmattso1]

Great vid, very informative and thorough. Thanks!