How to change every second row with different color - Excel 2003
I have a simple table and I would like to have every second row in different
color. How can I make it? Thanks |
How to change every second row with different color - Excel 2003
See http://www.xldynamic.com/source/xld.CF.html#rows
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "snah" wrote in message ... I have a simple table and I would like to have every second row in different color. How can I make it? Thanks |
How to change every second row with different color - Excel 2003
1 option is via a VBA Macro
"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 |
How to change every second row with different color - Excel 20
Very handy solution Bob -- Nice one
"Bob Phillips" wrote: See http://www.xldynamic.com/source/xld.CF.html#rows -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "snah" wrote in message ... I have a simple table and I would like to have every second row in different color. How can I make it? Thanks |
How to change every second row with different color - Excel 20
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 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "snah" wrote in message ... I have a simple table and I would like to have every second row in different color. How can I make it? Thanks |
How to change every second row with different color - Excel 20
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 "snah" wrote: 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 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "snah" wrote in message ... I have a simple table and I would like to have every second row in different color. How can I make it? Thanks |
How to change every second row with different color - Excel 2003
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 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 |
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 |
All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com