| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Customizing row color
Hi,
I need to have an excel worksheet where the first row is yellow, the second is green, the third red and the forth white. Then I need to repeat these through the worksheet. The columns are between A and F. I am new to excel programming. How does one approach this issue. I appreciate any help for resolution. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Customizing row color
as you only have three colors, you can use Conditional Formatting
use forrmula is and set these to 1) =MOD(ROW(),4)=1 set pattern to pastel yellow 2) =MOD(ROW(),4)=2 set pattern to pastel green 3) =MOD(ROW(),4)=3 set pattern to pastel red white is the default "Jack" wrote in message ... Hi, I need to have an excel worksheet where the first row is yellow, the second is green, the third red and the forth white. Then I need to repeat these through the worksheet. The columns are between A and F. I am new to excel programming. How does one approach this issue. I appreciate any help for resolution. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Customizing row color
Thanks Patrick for your help. I have put the first formula succesfully in the
formula section. This took care of the first color. How would I put the rest two formulas. Thanks. "Patrick Molloy" wrote: as you only have three colors, you can use Conditional Formatting use forrmula is and set these to 1) =MOD(ROW(),4)=1 set pattern to pastel yellow 2) =MOD(ROW(),4)=2 set pattern to pastel green 3) =MOD(ROW(),4)=3 set pattern to pastel red white is the default "Jack" wrote in message ... Hi, I need to have an excel worksheet where the first row is yellow, the second is green, the third red and the forth white. Then I need to repeat these through the worksheet. The columns are between A and F. I am new to excel programming. How does one approach this issue. I appreciate any help for resolution. Thanks. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Customizing row color
Press the Add button on the Conditional Formatting dialog box.
-- Rick (MVP - Excel) "Jack" wrote in message ... Thanks Patrick for your help. I have put the first formula succesfully in the formula section. This took care of the first color. How would I put the rest two formulas. Thanks. "Patrick Molloy" wrote: as you only have three colors, you can use Conditional Formatting use forrmula is and set these to 1) =MOD(ROW(),4)=1 set pattern to pastel yellow 2) =MOD(ROW(),4)=2 set pattern to pastel green 3) =MOD(ROW(),4)=3 set pattern to pastel red white is the default "Jack" wrote in message ... Hi, I need to have an excel worksheet where the first row is yellow, the second is green, the third red and the forth white. Then I need to repeat these through the worksheet. The columns are between A and F. I am new to excel programming. How does one approach this issue. I appreciate any help for resolution. Thanks. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Customizing row color
Thanks Rick for your help. When I added twice and put the formula as per
Patrick and then clicked ok nothing else changed except for the color pattern I already had. When I went back to the conditional formatting I saw that the added patterns have disappeared. May be I need to save the spreadsheet. Any thoughts "Rick Rothstein" wrote: Press the Add button on the Conditional Formatting dialog box. -- Rick (MVP - Excel) "Jack" wrote in message ... Thanks Patrick for your help. I have put the first formula succesfully in the formula section. This took care of the first color. How would I put the rest two formulas. Thanks. "Patrick Molloy" wrote: as you only have three colors, you can use Conditional Formatting use forrmula is and set these to 1) =MOD(ROW(),4)=1 set pattern to pastel yellow 2) =MOD(ROW(),4)=2 set pattern to pastel green 3) =MOD(ROW(),4)=3 set pattern to pastel red white is the default "Jack" wrote in message ... Hi, I need to have an excel worksheet where the first row is yellow, the second is green, the third red and the forth white. Then I need to repeat these through the worksheet. The columns are between A and F. I am new to excel programming. How does one approach this issue. I appreciate any help for resolution. Thanks. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Customizing row color
Never mind Rick. I got it.
"Rick Rothstein" wrote: Press the Add button on the Conditional Formatting dialog box. -- Rick (MVP - Excel) "Jack" wrote in message ... Thanks Patrick for your help. I have put the first formula succesfully in the formula section. This took care of the first color. How would I put the rest two formulas. Thanks. "Patrick Molloy" wrote: as you only have three colors, you can use Conditional Formatting use forrmula is and set these to 1) =MOD(ROW(),4)=1 set pattern to pastel yellow 2) =MOD(ROW(),4)=2 set pattern to pastel green 3) =MOD(ROW(),4)=3 set pattern to pastel red white is the default "Jack" wrote in message ... Hi, I need to have an excel worksheet where the first row is yellow, the second is green, the third red and the forth white. Then I need to repeat these through the worksheet. The columns are between A and F. I am new to excel programming. How does one approach this issue. I appreciate any help for resolution. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Customizing -2^2 | Excel Discussion (Misc queries) | |||
| Customizing Color Palette in Excel 2007 | Excel Discussion (Misc queries) | |||
| customizing text color | New Users to Excel | |||
| customizing chart column color formats in code | Excel Programming | |||
| customizing chart column color formats in code | Excel Programming | |||
Linear Mode
