Format alternating row colors?

[Bob Newman]

I have a spreadsheet (Excel 2010) that I would like to have every other rowwith a light green background to make the rows more readable. I know it can be done via formatting rather than do it manually (too unwieldly) but I don't know how to do it. Help please.

Bob

 

[Claus Busch]

Hi Bob,

Am Sat, 28 Sep 2013 11:15:14 -0700 (PDT) schrieb Bob Newman:

I have a spreadsheet (Excel 2010) that I would like to have every other row with a light green background to make the rows more readable. I know it can be done via formatting rather than do it manually (too unwieldly) but I don't know how to do it. Help please.

select your table from A1 on => Conditional Formatting => Use Formula
....=>
=MOD(SUBTOTAL(3,$A$1:$A1),2)=0
and format with light green background color.
This also works, if the table will be filtered


Regards
Claus B.

 

[Claus Busch]

Hi Bob,

Am Sat, 28 Sep 2013 11:15:14 -0700 (PDT) schrieb Bob Newman:

I have a spreadsheet (Excel 2010) that I would like to have every other row with a light green background to make the rows more readable. I know it can be done via formatting rather than do it manually (too unwieldly) but I don't know how to do it. Help please.

you can also select your table => Start => Styles => Format as Table


Regards
Claus B.

 

[Bob Newman]

Hi Bob,



Am Sat, 28 Sep 2013 11:15:14 -0700 (PDT) schrieb Bob Newman:






you can also select your table => Start => Styles => Format as Table





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

After I select my table where might I find the "Start" choice?

Bob

 

[Bob Newman]

Hi Bob,



Am Sun, 29 Sep 2013 05:29:49 -0700 (PDT) schrieb Bob Newman:






I meant tab "Start" into the ribbon





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

I'm sorry. I still don't understand what you mean by "tab "Start" into the ribbon".

Bob

 

[Claus Busch]

Hi Bob,

Am Sun, 29 Sep 2013 12:30:22 -0700 (PDT) schrieb Bob Newman:

I'm sorry. I still don't understand what you mean by "tab "Start" into the ribbon".

I'm sorry. In the english version the tab is named "Home"
Home => Styles => Format as Table


Regards
Claus B.

 

[Zaidy036]

I have a spreadsheet (Excel 2010) that I would like to have every other row with a light green background to make the rows more readable. I know it can be done via formatting rather than do it manually (too unwieldly) but I don't know how to do it. Help please.

Bob

Look at free ASAP Utilities http://www.asap-utilities.com/