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

Whatever

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"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#