Shade Every Other Row

Shade Every Other Row

HomeOther ContentShade Every Other Row
ChannelPublish DateThumbnail & View CountActions
Channel Avatar Doug H2012-09-16 18:04:12 Thumbnail
17,261 Views
Sometimes you just want to have stuff stand out in your Excel tables. Say you have a table of data and want every other row to be in a pink shade. Or you want ever just the odd row to be green. Or you want every 7th row to have a nice shade of yellow. The possibilities (and the color choices ) are endless! There are a couple of ways this could be done and in the video below I’ll show you two ways. One is using the table feature in Excel and the other is a bit more of a formula approach using the ROWS and MOD functions (along with conditional formatting).  

SUBSCRIBE to my channel https://goo.gl/wN3c3p

Excel Training https://www.exceltraining101.com/p/training.html

Excel Books & Tech Gear https://www.amazon.com/shop/dough

️ Tools: Screencasting https://techsmith.z6rjha.net/5Qe53

️ Tools: Microsoft Office https://microsoft.msafflnk.net/rKL0G

️ Tools: TubeBuddy https://www.tubebuddy.com/et101

This description may contain affiliate links and we’ll receive a small commission if a purchased is made using the links (but at no additional cost to you). It’ll support the channel and so more videos like this can be made. Thanks for your support!

If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: /”Convert Table in a PDF File to Excel/”
https://www.youtube.com/watch?v=COUOvhbQ4CQ
-~-~~-~~~-~~-~-

Please take the opportunity to connect and share this video with your friends and family if you find it useful.