So, if I use the ROW function without a reference to get number of the current ROW, and then use 2 as the divisor, the MOD function returns zero when the row is an even number and 1 if not. MOD takes a number and a divisor, then returns the remainder. The classic formula for zebra striping uses the MOD function. However, you can also apply dynamic zebra striping with conditional formatting and a formula. This is a good option, especially if you want the table for other reasons as well. To get shading on every other row, we could just convert this table to a proper Excel table using Control + T, then customize the format as desired. In this spreadsheet, we have a table of employees with a small amount of formatting. This is sometimes called "zebra striping". In this video, we'll look at how to use conditional formatting to shade every other row in a table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |