View Single Post
  #1   Report Post  
Brenda
 
Posts: n/a
Default How to highlight alternate rows

Hi,
I have a book of Excel formulas that gives the following formula to shade
alternate rows in a Workbook:
i.e. so the rows look grey, white, grey, white, etc.

=MOD(ROW( ),2)=0
Does anyone know if there's an error somewhere because I can't get it to
work. I typed it in the formula line...Maybe I'm supposed to enter a range
somewhere...not sure. Thanks.