Thread: How to change every second row with different color - Excel 2003
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How to change every second row with different color - Excel 2003
You could select the rows in the table and FormatConditional FormattingFormula
is

=MOD(ROW(),2)=1

Format to a nice color and OK


Gord Dibben MS Excel MVP




On Tue, 19 Jun 2007 06:38:38 -0700, snah wrote:

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

Reply With QuoteReply With Quote