Repeated shading of rows??

[Andy]

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?

 

[mmaatman]

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:

 

[Guest]

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

 

[Dave Peterson]

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.

 

[Dave Peterson]

I use this formula to shade the Weekends:

=WEEKDAY($A2,2)>5

 

[Andy]

That's great. Thank you.

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

 

[Andy]

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!

 

[Dave Peterson]

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

 

[Guest]

so.. with the row shading in place, now you're asking for the moon, huh <g> ?
see Dave's response ..