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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

*******I Need Help****** 7
Maintaining Background Colours of Tasks of a Subproject in the Master Project File? 0
Conditional format an entire row based on one cell 3
Couting based on color and Filter 1
Dealing with a Pivot Table (when I don't want to) 0
Formula Help 9
Formula to count Highlited Cells. 3
"Highlite" a "row" that has a "particular date" 0

Top