A quick and simple way to auto shade alternate rows in MS Excel 365 (as in video) works from Excel 2007 to current.
Formula from video: =MOD(ROW(),2)=0
From Channel: TDWTV1 – (http://www.youtube.com/channel/UCQ_nS_AZKMEdtY5lzrZBrJw)
Video URL: https://www.youtube.com/watch?v=ubvgAotyh_4