Format alternating row colors?

  • Thread starter Thread starter Bob Newman
  • Start date Start date
B

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
 
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.
Click to expand...

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.
 
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.
Click to expand...

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


Regards
Claus B.
 
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
Click to expand...

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

Bob
 
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
Click to expand...

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

Bob
 
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".
Click to expand...

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


Regards
Claus B.
 
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
Click to expand...
Look at free ASAP Utilities http://www.asap-utilities.com/
 
Back
Top