Select/highlight alternate cells

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

Guest

I would like to do something that should seemingly be simple. I would just like to take a very long catalog list and highlight alternating rows to make it easier to read across. How would I do this. I thought of a macro or conditional formatting but how would I compare row values?
 
cbdot,

Take a look here for some help with this:

http://www.cpearson.com/excel/banding.htm

John

cbdot said:
I would like to do something that should seemingly be simple. I would
Click to expand...
just like to take a very long catalog list and highlight alternating rows to
make it easier to read across. How would I do this. I thought of a macro
or conditional formatting but how would I compare row values?
 
One way:

1. Put this in the first row of a col. (say E) and fill
down as far as needed (say row 1000):
=MOD(ROW(),2)
2. Now select all the rows, 1-1000.
3. Go to Format > Conditional Formatting
4. Select Formula Is and put:
=$E1=1
5. Press the Format radio button and format as desired.

HTH
Jason
Atlanta, GA
-----Original Message-----
I would like to do something that should seemingly be
Click to expand...
simple. I would just like to take a very long catalog
list and highlight alternating rows to make it easier to
read across. How would I do this. I thought of a macro
or conditional formatting but how would I compare row
values?
 
An alternative which doesn't need a helper column

1. Select all the rows, 1-1000.
2. Go to Format > Conditional Formatting
3. Select Formula Is and put:
=Int(Row()/2)=Row()/2
4. Press the Format radio button and format as desired.


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top