View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default 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