Alternating Row and Column Colors and Other Formatting Options in Excel 

I did not know you had this type of video so many years ago. I'm subscribed from your more recent videos about personality disorders.

You can also try this with shorter formula =mod(row(),2)

Brilliant! Thanks a lot. You have no idea how useful this trick is to me! Saves a ton of time.

Thanks its easier than expected. Bless you for saving me precious time.

Thanks you! Ive been trying to do this all day and only found out how by your video!!

=odd(row())=row()

Great videos for the advanced and newbie. My question is: How can I change the color of the row and column number and letter when I highlight a cell. Example, yellow color in the box where the row number and column number are for the cell selected. Thanks.

I like your teaching, Sir. Thanks for teaching, sharing, and explanation.

am happy my problem is solved now. Big ups to you!

Great video! I currently have subtotals that are highlighted in yellow. I would like the other cells to be no fill and light grey (every other row). Is there a way to do this and still keep the subtotals highlighted in yellow?

Thanks!! Would have never figured that one out.

Thank you. You save my time.

Can I make the formatting for a dynamic range so that whenever any row is added, the formatting is applied

Dr Todd Grande Nice- This has cured my excel induced headache.

Been doing it the long way for 3 years now lol. Thanks 4 tha help

GREAT VIDEO...THANKS

many thnks! Helpful info

Is there any way to change the numbering of the rows themselves? I want a -1 Row or 0 Row number. So, I can do something.

Thanks a lot Todd!

Hi Dr Todd, can you help me (great video by the way made my life a lot easier. I use excel to log jobs, dates, costs, and expenses in rows. When a job has been invoiced I mark the whole row with a green background. If I mark the last row off green, when I start to fill in details on the row below they automatically show with a green background, can you tell me why and how I can stop this from happening?

Just what i want Thanks

I did a double take when I saw that this was Dr Grande's channel lol

How do I know what formula should I input in the field in case want some changes? It's confusing. How did you obtain that formula?

Very useful topic but cannot see properly the formula and heard voice... Can you upload one version after fixing above mentioned problems... Pls

Thank you for the video... What if I want to make a fill color pattern for every 30 rows for example?

Helpful. Thank you for sharing.

Any idea how to shade every third row? Thanks!

Thank you for this!!!!

Hi Brother, how did you turn the excel bar into purple? Thanks

Hi, what if i want to shade the rows starting from the B column? please help.

Helpful. Thank you. =mod(row(),2)

Thank you Dr. Grande.

So thanks to u sir.....

Very Helpful

I CAN HARDLY SEE THE FORMULA KINDLY ASSIST

Does this work with merged rows?

Hi.. Would you please explain how to lock the top horizontal row only? Thank you very much!

PERFECT!!!! Thank you so much.

I used this but sometimes I have to merge some rows. This made the shading not work.

How can you do this with some rows have merged cells in the beginning of the row and at the end of the row? I have employees names and ID# in first 2 cells (which have 2 cells merged for each cell). Then the last cell in each row also has 2 cells merged together. The cells inbetween those cells are not merged at all. The upper row in the non-merged cells is where I put dates in. The 2nd row in the non-merged rows is where I put the hours worked in. How can I have every other row (meaning 2 actual rows but the beginning and the end of the rows have 2 merged cells. I want the 2 single cell rows to be the same color as the beginning and end. I hope this makes sense. I would really love any help someone could give me. Thanks.

very good thanks

Thank you Sir

how is it I can't find a description or demo anywhere to just highlight every other change in value in a column. ARGH....

Thank you Doc!

Thank you very much!

Nice video, handy viewer hint (watch at 1.75 x Speed)

Thanks!

very helpfull, thak you

Thank you

Thank you so much

Thanks you, But your vedio clip is not clear found all are formula.

Thanks. Awesome.

This is great! Thank you!

THANKS :D

Not clear

is there a better program? like google sheets?

Click Home > Format as Table.

Very difficult to hear what you says...

Cant see blurry man

May be a good video if you spoke louder. Have to strain to hear anything.

nope did not work

Bro have some red bull lol

Helpful but talk faster damn lol

Cant hear you!! ARGH

Thank you

=odd(row())=row()