Excel VBA Macro: Apply Color Shading to Alternate Rows (Step-by-Step Tutorial)

preview_player
Показать описание
Excel VBA Macro: Apply Color Shading to Alternate Rows (Step-by-Step Tutorial). In this video we write code that helps us automatically shade alternate row color for an odd or even number of rows.

Data used in this video:

#ExcelVBA #ExcelMacro
Рекомендации по теме
Комментарии
Автор

Excellent tutorial, helped me out with a couple things I was having SERIOUS trouble with.... Thank You

Xlatty
Автор

Column A will be my base column. I’ll have a total of three columns. My question is how can I format blanks not to fill. The catch is, if there is nothing in Column A then the whole row is blank no color. However if there is something in Column A and the the cell for Column C on the same row is blank I still would want that filled in with the color of my choosing. Thank you

SheridanWhiteside
welcome to shbcf.ru