In the Format values where this formular is true box, type the formula: = MOD (ROW (), 2)> 0
Coloring alternating excel lines not everyone knows Picture 4
When you click Format, the Format Cells dialog box appears.
On the Fill tab, select the color you want, then select OK.
Coloring alternating excel lines not everyone knows Picture 5
After you press OK, let's see the results achieved offline!
Coloring alternating excel lines not everyone knows Picture 6
It's simple and fast, with 5 super-fast steps that can help you differentiate between different viewing lines in Excel.