Excel Tips: Highlight alternate rows with Conditional formatting

[@michellemendez8256]

The formula, for anyone else who is struggling to see it, is.. =isodd(row()) .. had to go to another video to figure it out but still appreciated the info!

[@jomccroskey7]

Thank you Michelle. Video was useless without your help.

[@thembilemajafe1165]

Thank you!

[@noaj1984]

after searching for 1,5 app. why the formula =mod(row.. etc doesn't work, I found you and your formula works!!!! thanks a lot. :D

[@jamesperry3837]

Thanks! Needed this today. =ISODD(row()) / =ISEVEN(row())......to be used in CF formula,

[@vasudeopatil7521]

Sir, I want to highlight date-wise data in an alternating pattern. The dates may follow any sequence (odd-even, even-odd, odd-odd, or even-even) from 1 to 31, and I would like to apply alternate highlighting.

[@muhammednisam1744]

Thank you so much for this video

[@PKAnExcelExpert]

Thanks for watching

[@varungupta5594]

AWESOME PK..always come up with innovative ideas!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@CalgaryChris]

Thanks for the tip!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mohammadbelal6428]

Thanks for this video.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@09shirish]

Thanks for learning !

[@PKAnExcelExpert]

Thanks for watching

[@kanhaiyalalsahani3556]

Hello PK: I wanted to know how if can apply the same formula for entire sheet. like when am entering any date in column and when i hit enter to move to next row the colour of next row automatically changes to different colour.

[@PhenomenonChu]

What is the formule if I want to highlight alternate rows with conditional formatting while using a filter ?

[@RitikaSharma-dg5zc]

Hi, can you please help me to understand a string with combination of if, Isnumder, search

[@milantamang1640]

thank you

[@PKAnExcelExpert]

Most welcome

[@srsandeepsinghnegi]

Thanks for the video.

[@amazon5665]

what is shortcut key for filter

[@PKAnExcelExpert]

Shift+Ctrl+L

[@amazon5665]

@@PKAnExcelExpert thank u very much

[@thedatalabs]

Nice tips

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pandatm66]

Thank yoooou

[@rinkusvlogsandlifestyle]

Formula you type is not visible..pls write it here

[@buddhaswag9066]

Indian man strikes again on explaining specific stuff lmao

[@paravej]

I already seen this trick in Mr Sujeet Video.