How to change every second row with different color

How to change every second row with different color - Excel 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

snah - 19 Jun 2007 14:38 GMT

I have a simple table and I would like to have every second row in different
color.
How can I make it?
Thanks

Reply to this Message

Bob Phillips - 19 Jun 2007 14:47 GMT

See http://www.xldynamic.com/source/xld.CF.html#rows

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I have a simple table and I would like to have every second row in
>different
> color.
> How can I make it?
> Thanks

Reply to this Message

steve_doc - 19 Jun 2007 15:04 GMT

Very handy solution Bob -- Nice one

> See http://www.xldynamic.com/source/xld.CF.html#rows
>
[quoted text clipped - 3 lines]
> > How can I make it?
> > Thanks

Reply to this Message

snah - 19 Jun 2007 15:08 GMT

Thank you Bob
But if I put the code in my table I get an formula error.
Works this code by you?

=MOD(ROW(),2)=0

In Excel input field are marked those characters: ,2

Thanks Jan

Bob Phillips píše:

> See http://www.xldynamic.com/source/xld.CF.html#rows
>
[quoted text clipped - 3 lines]
> > How can I make it?
> > Thanks

Reply to this Message

steve_doc - 19 Jun 2007 15:14 GMT

Hi Jan

You need to enter that formula into the conditional Format dialog box - not
on your worksheet

Select the range that you want eg A2:H22
Format/Conditional Formating

Change the "Cell Value Is" to "Formula is" and enter the formula in the next
text box

HTH

> Thank you Bob
> But if I put the code in my table I get an formula error.
[quoted text clipped - 15 lines]
> > > How can I make it?
> > > Thanks

Reply to this Message

steve_doc - 19 Jun 2007 14:50 GMT

1 option is via a VBA Macro

> I have a simple table and I would like to have every second row in different
> color.
> How can I make it?
> Thanks

Reply to this Message

gls858 - 19 Jun 2007 15:38 GMT

> I have a simple table and I would like to have every second row in different
> color.
> How can I make it?
> Thanks

I see you have several solutions. Here's an additional one.
I use a free program called ASAP Utilities.

http://www.asap-utilities.com/

The program contains MANY useful functions. One of which is
color every nth row.

Standard disclaimer: not associated with or receive compensation from
yada yada.

gls858

Reply to this Message

Gord Dibben - 19 Jun 2007 16:40 GMT

You could select the rows in the table and Format>Conditional Formatting>Formula
is

=MOD(ROW(),2)=1

Format to a nice color and OK

Gord Dibben MS Excel MVP

>I have a simple table and I would like to have every second row in different
>color.
>How can I make it?
>Thanks

Reply to this Message

Rate this thread: