Alternate Row Shading

  • Thread starter Thread starter Alex_Bachrach
  • Start date Start date
A

Alex_Bachrach

I'm a newbie who's got a five-column worksheet and about 900 rows, most of
them already typed. Grateful if someone could advise how to shade all of
the rows in an alternate fashion, i.e., light-gray, then dark-gray, etc.

Thanks!
AB
 
You can use Conditional Formatting for that, using 2 conditions. One
condition for odd numbered rows and another for even numbered rows...

1) Select the range of cells
2) Format > Conditional Formatting
3) Condition 1 > Formula Is, and enter the following formula:
=MOD(ROW(),2)=1
4) Choose your formatting for this condition
5) Click "Add"
6) Condition 2 > Formula Is, and enter the following formula:
=MOD(ROW(),2)=0
7) Choose your formatting for this condition
8) Click "OK'

Hope this helps!
 
Thanks Domenic- worked like a charm!

AB

Domenic said:
You can use Conditional Formatting for that, using 2 conditions. One
condition for odd numbered rows and another for even numbered rows...

1) Select the range of cells
2) Format > Conditional Formatting
3) Condition 1 > Formula Is, and enter the following formula:
=MOD(ROW(),2)=1
4) Choose your formatting for this condition
5) Click "Add"
6) Condition 2 > Formula Is, and enter the following formula:
=MOD(ROW(),2)=0
7) Choose your formatting for this condition
8) Click "OK'

Hope this helps!
Click to expand...
 
Back
Top