How to highlight alternate rows

B

Brenda

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.
 

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

Apply Alternate Shading to selected rows 2
Alternate grey shading for selected rows of a table 5
If using =MOD(ROW(),2)=0 conditional formatting and want diff fill 1
Alternate Row Coloring 7
filtered rows getting shaded alternately (conditional formatting) 0
Alternate Column Shading to be applied only to visible columns 6
Shading alternate "groups" of rows? 6
alternate row shading kept with autofilter 3

Top