Highlite every 2nd row with a colour

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

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
Conditional format an entire row based on one cell 3
Couting based on color and Filter 1
How to highlite the row and colum of the active cell? 2
Formula to count Highlited Cells. 3
row won't unhide 4
How can I highlite an entire row using conditional formatting? 4
working with #N/A and conditional formating 1

Back
Top