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.

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" <(E-Mail Removed)> wrote in message
news:83A2EBE4-CB6C-4A12-B332-(E-Mail Removed)...
> 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.

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" <(E-Mail Removed)> wrote in message
> news:83A2EBE4-CB6C-4A12-B332-(E-Mail Removed)...
> > 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.
>
>

Press the Add button on the Conditional Formatting dialog box.

--
Rick (MVP - Excel)


"Jack" <(E-Mail Removed)> wrote in message
news:18CDB40E-D7E8-43FA-B1FD-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:83A2EBE4-CB6C-4A12-B332-(E-Mail Removed)...
>> > 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.
>>
>>

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" <(E-Mail Removed)> wrote in message
> news:18CDB40E-D7E8-43FA-B1FD-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:83A2EBE4-CB6C-4A12-B332-(E-Mail Removed)...
> >> > 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.
> >>
> >>
>
>

Never mind Rick. I got it.

"Rick Rothstein" wrote:

> Press the Add button on the Conditional Formatting dialog box.
>
> --
> Rick (MVP - Excel)
>
>
> "Jack" <(E-Mail Removed)> wrote in message
> news:18CDB40E-D7E8-43FA-B1FD-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:83A2EBE4-CB6C-4A12-B332-(E-Mail Removed)...
> >> > 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.
> >>
> >>
>
>