Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change even rows to a predefined colour
I want to run code that will change even numbered rows to a predefined
colour in the range 10:100 Any suggestions? thank you Pat |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change even rows to a predefined colour
Pat,
Take a look at http://www.xldynamic.com/source/xld.CF.html#rows -- HTH RP (remove nothere from the email address if mailing direct) "Pat" wrote in message ... I want to run code that will change even numbered rows to a predefined colour in the range 10:100 Any suggestions? thank you Pat |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change even rows to a predefined colour
Click in the row-header of Row 10. The entire Row (10) should be selected.
At the Menu, Click on Format, Conditional Formatting; At drop down select FormulaIS and in the box put in: =IF(MOD(ROW(),2)=0,TRUE) - then select your color, and then OK out. Your Row 10 should change immediately to the desired color. Now Click again in the Row Header of Row 10; At the Menu Click on the Format-Painter (the Paint-Brush Icon) then left click and hold down on the row header of Row 11 and drag down the Row header Column to Row 100 and let go of your Mouse; Done HTH "Pat" wrote in message ... I want to run code that will change even numbered rows to a predefined colour in the range 10:100 Any suggestions? thank you Pat |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change even rows to a predefined colour
Hi Jim,
You don't need to do an IF test. CF only wants a TRUE or FALSE to determine whether to set the format, and the expression =MOD(ROW(),2)=0 returns TRUE or FALSE, so that is sufficient. -- HTH RP (remove nothere from the email address if mailing direct) "JMay" wrote in message news:VcKZd.86693$%U2.35857@lakeread01... Click in the row-header of Row 10. The entire Row (10) should be selected. At the Menu, Click on Format, Conditional Formatting; At drop down select FormulaIS and in the box put in: =IF(MOD(ROW(),2)=0,TRUE) - then select your color, and then OK out. Your Row 10 should change immediately to the desired color. Now Click again in the Row Header of Row 10; At the Menu Click on the Format-Painter (the Paint-Brush Icon) then left click and hold down on the row header of Row 11 and drag down the Row header Column to Row 100 and let go of your Mouse; Done HTH "Pat" wrote in message ... I want to run code that will change even numbered rows to a predefined colour in the range 10:100 Any suggestions? thank you Pat |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change even rows to a predefined colour
Yeah, Thanks Bob
Hopefully I can remember that TRUTH. Jim "Bob Phillips" wrote in message ... Hi Jim, You don't need to do an IF test. CF only wants a TRUE or FALSE to determine whether to set the format, and the expression =MOD(ROW(),2)=0 returns TRUE or FALSE, so that is sufficient. -- HTH RP (remove nothere from the email address if mailing direct) "JMay" wrote in message news:VcKZd.86693$%U2.35857@lakeread01... Click in the row-header of Row 10. The entire Row (10) should be selected. At the Menu, Click on Format, Conditional Formatting; At drop down select FormulaIS and in the box put in: =IF(MOD(ROW(),2)=0,TRUE) - then select your color, and then OK out. Your Row 10 should change immediately to the desired color. Now Click again in the Row Header of Row 10; At the Menu Click on the Format-Painter (the Paint-Brush Icon) then left click and hold down on the row header of Row 11 and drag down the Row header Column to Row 100 and let go of your Mouse; Done HTH "Pat" wrote in message ... I want to run code that will change even numbered rows to a predefined colour in the range 10:100 Any suggestions? thank you Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change colour of rows in a worksheet | Excel Discussion (Misc queries) | |||
How can I change the predefined headers and footers in Excel? | Excel Discussion (Misc queries) | |||
Change colour of cells when content is altered/changed BUT NOT TO INSERTED OR DELETED ROWS | Excel Discussion (Misc queries) | |||
Creating a new worksheet using predefined rows | Excel Worksheet Functions | |||
Formula to change rows a different colour? | Excel Worksheet Functions |