Answers for "how to make every other row different colors in excel"

1

excel bold alternating rows

select your rows > 
conditional formatting > 
add your own formula > 
=mod(row(),2)=1  >
select the style for chosen rows.

.................................
the formula applies the formatting to every ODD row. 
owing to the modulo (remainder) of the row number/2 = 1.
Posted by: Guest on November-12-2020

Code answers related to "how to make every other row different colors in excel"

Browse Popular Code Answers by Language