G Guest Jun 19, 2007 #1 I have a simple table and I would like to have every second row in different color. How can I make it? Thanks
I have a simple table and I would like to have every second row in different color. How can I make it? Thanks
B Bob Phillips Jun 19, 2007 #2 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)
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)
G Guest Jun 19, 2007 #4 Very handy solution Bob -- Nice one Bob Phillips said: 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) Click to expand...
Very handy solution Bob -- Nice one Bob Phillips said: 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) Click to expand...
G Guest Jun 19, 2007 #5 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:
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:
G Guest Jun 19, 2007 #6 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
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
G gls858 Jun 19, 2007 #7 snah said: I have a simple table and I would like to have every second row in different color. How can I make it? Thanks Click to expand... 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
snah said: I have a simple table and I would like to have every second row in different color. How can I make it? Thanks Click to expand... 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
G Gord Dibben Jun 19, 2007 #8 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
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
