Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shading alternate "groups" of rows? | Excel Worksheet Functions | |||
Outlining - collapse rows based on repeated column value | Excel Discussion (Misc queries) | |||
(Unsuccessfully!) Unhiding Rows in Excel 2003 | Excel Worksheet Functions | |||
Automatically inserting rows | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) |