Highlight Alternate Rows (or Every Third/Fourth Row) in Excel - Using Formula

[@tawsifislam-accafinalist2796]

You are an amazing Tutor. Your way of teaching excel is superb. God bless You for helping us with a good heart.

[@trumpexcel]

Thank you so much for the kind words. Glad you found the video useful :)

[@harshitgupta6854]

after selection how to extract only Highlights cells Data

[@OzduSoleilDATA]

Very VERY nicoe solution. It's also good to see you on the screen. 👍👍👍

[@trumpexcel]

Thanks Oz.. It took so much effort to have the setup and get the video out. I need to learn how to do this better from you.

[@MohAboAbdo]

Thank you very much my dear professor for this wonderful video, and on this method the coolest.

[@jaishrisaxena1083]

Very nice way of teaching, any one can understand very well Pronunciation is very clear too.For future videos please provide practice file too.just a request. -Thanks

[@sekiondowarema1786]

Thanks for ur face my teacher. Thanks for ur excel lesson because u make me shine.....

[@Akashsuchandra]

Thank you very much my dear Sir for this wonderful video and on this method the coolest.

[@85MA]

It was amazing to learn with you. Thanks for helping us learn! I have a scenario where I have data in Column B2 to H2 and Row 2 to Row 10. I want to highlight every 4th row, but I don't want to highlight the entire 4th row, only from Column D2 to F2. Is it possible to highlight in this way? The thing to remember is that the data is in Excel worksheet not in table

[@MaMuNAcademY]

Wao... You are my idol. First time i have seen you at camera face...

[@bycottfrenchproducts.mukht1189]

First time u on cam good to see.

[@bazlurrahman9257]

Thank you very much for this video...

[@davidfovargue9164]

Hi just watched your video and applied to one of my sheets which i have been trying to get to highlight every block of 10 merged cells which contain days of the week every 28 days when i put 28 in the formula it highlights every `14 days if i change to 56 it then works for 28 days please could you advise thanks Dave

[@DarkWhisperer13]

How do you do dynamic alternative?

[@cnn4306]

Hi Sumit, thanks for sharing. Would be great to have an illustration of dynamic button for live charts, i.e. click by sales area button to reflect different live charts... Thanks.

[@sarahmann6522]

THANK YOU!

[@amardeepbhardwaj6036]

Plz Reply On this Comment 🙏🙏 In Your Playlist Section One playlist that is Basic to Advanced....Are these Full Excel Videos which Covers the Whole Info And Use Of MS-Excel??

[@harshitgupta6854]

after selection how to extract only Highlights cells Data

[@wayneedmondson1065]

Hi Sumit.. great tip.. thanks! One trick I employ is to use expanding ROWS() instead of ROW() inside MOD() which protects the integrity of the table highlighting, in case rows are inserted above the table. So, in your example, I would use: =MOD(ROWS($A$1:A2),2)=1 to have the first row of the table (row 2 of the worksheet) as FALSE or no highlight and then alternating from there. If I insert rows above the column headers to move the table down, the first row of the table always remains as non-highlighted. Using the ROW() method, each insertion would switch the result of the MOD() formula and change the position of the highlights. It's a slight difference from your approach, but works for me in cases where I might ultimately end up moving the position of the table with inserts. If no table move is anticipated, then your method is easier to write. Always multiple ways to solve things with EXCEL. Thanks for sharing your vast knowledge in your great videos and on your web site and for providing the inspiration for me to tinker and create new solutions. Thumbs up!

[@briancowan21]

Wayne Edmondson , how can I highlight double alternating rows, highlight 1&2 then 5&6 then 9&10 etc

[@wayneedmondson1065]

@@briancowan21 Hi Brian.. thanks for your question. Building on what I wrote above, the following formula will work: =MOD(ROWS(A$2:A2)-1,4)1. I hope this helps. Good luck with your project!

[@RaviKumar-hq6be]

Tq tq so much bro

[@OfMelodies]

Hi Sumit. Can you please fix the downlink link for your Google Sheets Leave Tracker? The link is broken and I've tried reaching out to you about this on multiple platforms. Hoping that you can see this and update the link. Myself and others really need this tracker.

[@briandennehy6380]

Very nice thanks

[@jamespyle6398]

What about highlight 5 rows, every 5 rows?

[@shaheerpv9826]

Dear sir, thanks

[@annejacobsenhampson]

Thank you! :)

[@rakhigaur3043]

Thanks

[@chantiaru2270]

Hi Dear, pl make videos on MS Word, & Power Point

[@Exceltrick4u]

Nice

[@md.saifulislamtuku9303]

1st time view

[@betterdaysarecomingorconti360]

Thanks