Highlite every 2nd row with a colour
 

How can I highlite every second row in my spreadsheet with a colour or shade
to it makes it easier to read / follow?

Thanks !

Ty

Highlite every 2nd row with a colour
 

Highlight the whole worksheet and select Format-Conditional Formatting

Select "Formula Is" and insert this formula
=MOD(ROW(),2)=0
Hit the format button ande select the background color you want
Click Okay
Click Okay

"Ty" wrote:

How can I highlite every second row in my spreadsheet with a colour or shade
to it makes it easier to read / follow?

Thanks !

Ty