Highlite every 2nd row with a colour

T

Ty

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
 
S

Sloth

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
 
Top