Conditional formatting excel 2016 alternate row color
![conditional formatting excel 2016 alternate row color conditional formatting excel 2016 alternate row color](https://trumpexcel.com/wp-content/uploads/2013/11/Conditional-Formatting-in-Excel-Duplicate.png)
So, instead of this MOD formula, I could just use ISEVEN with ROW. Later versions of Excel allow you to use two special functions, ISODD, and ISEVEN in conditional formatting rules. If you'd rather shade even rows, just add "= 0" to the formula to change the logic. So, to add the striping, I can just create a new conditional formatting based on a formula.then add the formula, and set a fill color. We can use these results directly in a conditional formatting rule, since 1 and zero are equivalent to TRUE and FALSE. If I copy this formula across multiple cells, you can see we get rows of ones and zeros. 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".
![conditional formatting excel 2016 alternate row color conditional formatting excel 2016 alternate row color](https://www.spreadsheetweb.com/wp-content/uploads/2021/06/How-to-alternate-row-color-based-on-group-in-Excel-00-min.png)
CONDITIONAL FORMATTING EXCEL 2016 ALTERNATE ROW COLOR HOW TO
In this video, we'll look at how to use conditional formatting to shade every other row in a table.