Repeated shading of rows??
 

I want to create simple planner/calendar:

(a) Dates on the left
(b) One line for each day.
(c) The rest of the line going across the page for my text.

I would like to shade in every seventh row.

Can I do this shading automatically with Excel 2003?

Repeated shading of rows??
 

Why bother,

You only have to select every 7th row and shade it
At the most you have to select 53 rows if you have a calendar for 1
year

Greetz from the Netherlands


Andy schreef:

I want to create simple planner/calendar:

(a) Dates on the left
(b) One line for each day.
(c) The rest of the line going across the page for my text.

I would like to shade in every seventh row.

Can I do this shading automatically with Excel 2003?

Repeated shading of rows??
 

Select the entire sheet (with A1 active)
Then click Format Conditional Formatting
For Condition 1,
Formula is: =MOD(ROW(),7)=0
Format: light green fill OK out
The above will shade rows 7, 14, 21, etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Andy" wrote:
I want to create simple planner/calendar:

(a) Dates on the left
(b) One line for each day.
(c) The rest of the line going across the page for my text.

I would like to shade in every seventh row.

Can I do this shading automatically with Excel 2003?

Repeated shading of rows??
 

Chip Pearson shows how to use Format|Conditional formatting to shade certain
rows:

http://cpearson.com/excel/banding.htm

But since you have dates in column A, I'd just depend on that.

Say you have headers in row 1.

Then select your range (A2:x9999)
and with A2 the activecell
format|conditional formatting
formula is: =weekday($a2)=1
and give it a nice format.

=Weekday() will return 1 for Sunday, 2 for Monday, ..., 7 for Saturday)

========
I use this formula to shade both Saturday and Sunday:

=WEEKDAY($A2,2)

Look at Excel's help to see what adding that second argument does to the
function.




Andy wrote:

I want to create simple planner/calendar:

(a) Dates on the left
(b) One line for each day.
(c) The rest of the line going across the page for my text.

I would like to shade in every seventh row.

Can I do this shading automatically with Excel 2003?

--

Dave Peterson

Repeated shading of rows??
 

I use this formula to shade the Weekends:

=WEEKDAY($A2,2)5



Dave Peterson wrote:

Chip Pearson shows how to use Format|Conditional formatting to shade certain
rows:

http://cpearson.com/excel/banding.htm

But since you have dates in column A, I'd just depend on that.

Say you have headers in row 1.

Then select your range (A2:x9999)
and with A2 the activecell
format|conditional formatting
formula is: =weekday($a2)=1
and give it a nice format.

=Weekday() will return 1 for Sunday, 2 for Monday, ..., 7 for Saturday)

========
I use this formula to shade both Saturday and Sunday:

=WEEKDAY($A2,2)

Look at Excel's help to see what adding that second argument does to the
function.

Andy wrote:

I want to create simple planner/calendar:

(a) Dates on the left
(b) One line for each day.
(c) The rest of the line going across the page for my text.

I would like to shade in every seventh row.

Can I do this shading automatically with Excel 2003?

--

Dave Peterson

--

Dave Peterson

Repeated shading of rows??
 

That's great. Thank you.

Now all I need are the times of sunrise & sunset plus the moon's
phases and I am rocking!



On 23 Sep 2006, Dave Peterson wrote:

Chip Pearson shows how to use Format|Conditional formatting to
shade certain rows:

http://cpearson.com/excel/banding.htm

But since you have dates in column A, I'd just depend on that.

Say you have headers in row 1.

Then select your range (A2:x9999)
and with A2 the activecell
format|conditional formatting
formula is: =weekday($a2)=1
and give it a nice format.

=Weekday() will return 1 for Sunday, 2 for Monday, ..., 7 for
Saturday)

========
I use this formula to shade both Saturday and Sunday:

=WEEKDAY($A2,2)

Look at Excel's help to see what adding that second argument does
to the function.




Andy wrote:

I want to create simple planner/calendar:

(a) Dates on the left
(b) One line for each day.
(c) The rest of the line going across the page for my text.

I would like to shade in every seventh row.

Can I do this shading automatically with Excel 2003?

Repeated shading of rows??
 

On 23 Sep 2006, ?B?TWF4?= wrote:

Select the entire sheet (with A1 active)
Then click Format Conditional Formatting
For Condition 1,
Formula is: =MOD(ROW(),7)=0
Format: light green fill OK out
The above will shade rows 7, 14, 21, etc


Thank you. As I said to Dave in another part of the thread ... the next
thig to add are the times of sunrise & sunset plus the moon's phases.

Then I will be in heaven. Heh!

Repeated shading of rows??
 

This may help:
http://www.timeanddate.com/calendar/



Andy wrote:

That's great. Thank you.

Now all I need are the times of sunrise & sunset plus the moon's
phases and I am rocking!

On 23 Sep 2006, Dave Peterson wrote:

Chip Pearson shows how to use Format|Conditional formatting to
shade certain rows:

http://cpearson.com/excel/banding.htm

But since you have dates in column A, I'd just depend on that.

Say you have headers in row 1.

Then select your range (A2:x9999)
and with A2 the activecell
format|conditional formatting
formula is: =weekday($a2)=1
and give it a nice format.

=Weekday() will return 1 for Sunday, 2 for Monday, ..., 7 for
Saturday)

========
I use this formula to shade both Saturday and Sunday:

=WEEKDAY($A2,2)

Look at Excel's help to see what adding that second argument does
to the function.




Andy wrote:

I want to create simple planner/calendar:

(a) Dates on the left
(b) One line for each day.
(c) The rest of the line going across the page for my text.

I would like to shade in every seventh row.

Can I do this shading automatically with Excel 2003?


--

Dave Peterson

Repeated shading of rows??
 

so.. with the row shading in place, now you're asking for the moon, huh <g ?
see Dave's response ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Andy" wrote:
Thank you. As I said to Dave in another part of the thread ... the next
thig to add are the times of sunrise & sunset plus the moon's phases.

Then I will be in heaven. Heh!