Programming dates color changes for calendar

[GoBonnieGo]

I'm not sure where to put this question.

I work for a fire department. We have three shifts. Every year, I make up
a 12 month calendar and go through and change the colors of the dates to 3
colors (they work 24 on, 48 off, so one color for each shift). Is there ANY
way to do this easier? It seems like there should be a way to run a small
program within Word to have it color them since the formula (day 1 blue, day
2 red, day 3 green, day 4 blue, etc.) seems simple enough.

I've asked the same question in Word and don't know if Publisher would be
any better.

Bonnie

 

[JoAnn Paules]

I would do that in Excel and use conditional formatting. No VBA required.
;-)

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

 

[GoBonnieGo]

Could you give me a hint on how to do it in Excel? Plus, this is a calendar
so other things go in the cell; holidays and such. Those should be in black,
plus I have trouble doing line spacing inside Excel. Any easy fixes?

I would do that in Excel and use conditional formatting. No VBA required.
;-)

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

I'm not sure where to put this question.

I work for a fire department. We have three shifts. Every year, I make
up
a 12 month calendar and go through and change the colors of the dates to 3
colors (they work 24 on, 48 off, so one color for each shift). Is there
ANY
way to do this easier? It seems like there should be a way to run a small
program within Word to have it color them since the formula (day 1 blue,
day
2 red, day 3 green, day 4 blue, etc.) seems simple enough.

I've asked the same question in Word and don't know if Publisher would be
any better.

Bonnie

 

[Mary Sauer]

In Publisher and in Word too you can create text styles, this might be your
solution. There is a full description on how to in the help files.

--
Mary Sauer MSFT MVP
http://office.microsoft.com/

Could you give me a hint on how to do it in Excel? Plus, this is a calendar
so other things go in the cell; holidays and such. Those should be in black,
plus I have trouble doing line spacing inside Excel. Any easy fixes?

I would do that in Excel and use conditional formatting. No VBA required.
;-)

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

I'm not sure where to put this question.

I work for a fire department. We have three shifts. Every year, I make
up
a 12 month calendar and go through and change the colors of the dates to 3
colors (they work 24 on, 48 off, so one color for each shift). Is there
ANY
way to do this easier? It seems like there should be a way to run a small
program within Word to have it color them since the formula (day 1 blue,
day
2 red, day 3 green, day 4 blue, etc.) seems simple enough.

I've asked the same question in Word and don't know if Publisher would be
any better.

Bonnie

 

[GoBonnieGo]

That was actually the first place I checked. I've run this question through
help every which way I can think of with no satisfying result. My problem is
the three colors. I need the dates to change colors every day and repeat in
the same order after 3 days. Maybe I just not asking help correctly. Any
hints?

In Publisher and in Word too you can create text styles, this might be your
solution. There is a full description on how to in the help files.

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

Could you give me a hint on how to do it in Excel? Plus, this is a calendar
so other things go in the cell; holidays and such. Those should be in black,
plus I have trouble doing line spacing inside Excel. Any easy fixes?

I would do that in Excel and use conditional formatting. No VBA required.
;-)

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


I'm not sure where to put this question.

I work for a fire department. We have three shifts. Every year, I make
up
a 12 month calendar and go through and change the colors of the dates to 3
colors (they work 24 on, 48 off, so one color for each shift). Is there
ANY
way to do this easier? It seems like there should be a way to run a small
program within Word to have it color them since the formula (day 1 blue,
day
2 red, day 3 green, day 4 blue, etc.) seems simple enough.

I've asked the same question in Word and don't know if Publisher would be
any better.

Bonnie

 

[JoAnn Paules]

http://support.microsoft.com/kb/268568
This tells you how to shade every other row in Excel. By tweaking the
numbers in the formula, you can tell it to shade every third row. If you use
a calendar template, that will help with the row height but it changes the
formula you'll need for the colors.

I have a feeling you are going to have a bit of work ahead of you. I would
be tempted to use a non-typical format. Maybe dates on the left side and
employee name across the top. Try posting in an Excel newsgroup - I'll bet
someone over there can help you. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

Could you give me a hint on how to do it in Excel? Plus, this is a
calendar
so other things go in the cell; holidays and such. Those should be in
black,
plus I have trouble doing line spacing inside Excel. Any easy fixes?

I would do that in Excel and use conditional formatting. No VBA required.
;-)

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

I'm not sure where to put this question.

I work for a fire department. We have three shifts. Every year, I
make
up
a 12 month calendar and go through and change the colors of the dates
to 3
colors (they work 24 on, 48 off, so one color for each shift). Is
there
ANY
way to do this easier? It seems like there should be a way to run a
small
program within Word to have it color them since the formula (day 1
blue,
day
2 red, day 3 green, day 4 blue, etc.) seems simple enough.

I've asked the same question in Word and don't know if Publisher would
be
any better.

Bonnie

 

[GoBonnieGo]

Thanks anyway. I probably haven't explained it clearly. I only want to
change the color of the numbers, not the entire cell.

A shift consists of almost a dozen employees, so including their names won't
work. And, as I stated before, other things have to go into these cells and
line breaks with cells never worked real well for me.

I guess it's back to doing it by hand.

Again, thanks anyway.

Bonnie

http://support.microsoft.com/kb/268568
This tells you how to shade every other row in Excel. By tweaking the
numbers in the formula, you can tell it to shade every third row. If you use
a calendar template, that will help with the row height but it changes the
formula you'll need for the colors.

I have a feeling you are going to have a bit of work ahead of you. I would
be tempted to use a non-typical format. Maybe dates on the left side and
employee name across the top. Try posting in an Excel newsgroup - I'll bet
someone over there can help you. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

Could you give me a hint on how to do it in Excel? Plus, this is a
calendar
so other things go in the cell; holidays and such. Those should be in
black,
plus I have trouble doing line spacing inside Excel. Any easy fixes?

I would do that in Excel and use conditional formatting. No VBA required.
;-)

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


I'm not sure where to put this question.

I work for a fire department. We have three shifts. Every year, I
make
up
a 12 month calendar and go through and change the colors of the dates
to 3
colors (they work 24 on, 48 off, so one color for each shift). Is
there
ANY
way to do this easier? It seems like there should be a way to run a
small
program within Word to have it color them since the formula (day 1
blue,
day
2 red, day 3 green, day 4 blue, etc.) seems simple enough.

I've asked the same question in Word and don't know if Publisher would
be
any better.

Bonnie

 

[eezzell]

I looked into what it would take to make a macro and it gets pretty involved
since column headings have their own cells and empty days have their own
cells, etc. But doing it by hand doesn't seem all that involved as long as
you do one color at a time since the font color chooser stays on the last
choice. So for instance, after selecting the first day and making it red,
select the fourth day and click on the color, select the seventh day and
click the color, etc. Then do the blue for the whole year. And so on. I did
this for one month and it took 2 1/2 minutes. If you did it with styles (as
per Mary's suggestion) i.e. day1style, day2style, day3style it would take a
little longer but you would have the advantage of being able to change the
colors by modifying the style.
--
Computing should be about insight, not numbers or flash.

Thanks anyway. I probably haven't explained it clearly. I only want to
change the color of the numbers, not the entire cell.

A shift consists of almost a dozen employees, so including their names won't
work. And, as I stated before, other things have to go into these cells and
line breaks with cells never worked real well for me.

I guess it's back to doing it by hand.

Again, thanks anyway.

Bonnie

http://support.microsoft.com/kb/268568
This tells you how to shade every other row in Excel. By tweaking the
numbers in the formula, you can tell it to shade every third row. If you use
a calendar template, that will help with the row height but it changes the
formula you'll need for the colors.

I have a feeling you are going to have a bit of work ahead of you. I would
be tempted to use a non-typical format. Maybe dates on the left side and
employee name across the top. Try posting in an Excel newsgroup - I'll bet
someone over there can help you. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

Could you give me a hint on how to do it in Excel? Plus, this is a
calendar
so other things go in the cell; holidays and such. Those should be in
black,
plus I have trouble doing line spacing inside Excel. Any easy fixes?

:

I would do that in Excel and use conditional formatting. No VBA required.
;-)

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


I'm not sure where to put this question.

I work for a fire department. We have three shifts. Every year, I
make
up
a 12 month calendar and go through and change the colors of the dates
to 3
colors (they work 24 on, 48 off, so one color for each shift). Is
there
ANY
way to do this easier? It seems like there should be a way to run a
small
program within Word to have it color them since the formula (day 1
blue,
day
2 red, day 3 green, day 4 blue, etc.) seems simple enough.

I've asked the same question in Word and don't know if Publisher would
be
any better.

Bonnie

 

[GoBonnieGo]

That was exactly the way I did it before. Oh well. Back to doing it by
hand.

Bonnie

I looked into what it would take to make a macro and it gets pretty involved
since column headings have their own cells and empty days have their own
cells, etc. But doing it by hand doesn't seem all that involved as long as
you do one color at a time since the font color chooser stays on the last
choice. So for instance, after selecting the first day and making it red,
select the fourth day and click on the color, select the seventh day and
click the color, etc. Then do the blue for the whole year. And so on. I did
this for one month and it took 2 1/2 minutes. If you did it with styles (as
per Mary's suggestion) i.e. day1style, day2style, day3style it would take a
little longer but you would have the advantage of being able to change the
colors by modifying the style.
--
Computing should be about insight, not numbers or flash.

Thanks anyway. I probably haven't explained it clearly. I only want to
change the color of the numbers, not the entire cell.

A shift consists of almost a dozen employees, so including their names won't
work. And, as I stated before, other things have to go into these cells and
line breaks with cells never worked real well for me.

I guess it's back to doing it by hand.

Again, thanks anyway.

Bonnie

http://support.microsoft.com/kb/268568
This tells you how to shade every other row in Excel. By tweaking the
numbers in the formula, you can tell it to shade every third row. If you use
a calendar template, that will help with the row height but it changes the
formula you'll need for the colors.

I have a feeling you are going to have a bit of work ahead of you. I would
be tempted to use a non-typical format. Maybe dates on the left side and
employee name across the top. Try posting in an Excel newsgroup - I'll bet
someone over there can help you. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


Could you give me a hint on how to do it in Excel? Plus, this is a
calendar
so other things go in the cell; holidays and such. Those should be in
black,
plus I have trouble doing line spacing inside Excel. Any easy fixes?

:

I would do that in Excel and use conditional formatting. No VBA required.
;-)

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


I'm not sure where to put this question.

I work for a fire department. We have three shifts. Every year, I
make
up
a 12 month calendar and go through and change the colors of the dates
to 3
colors (they work 24 on, 48 off, so one color for each shift). Is
there
ANY
way to do this easier? It seems like there should be a way to run a
small
program within Word to have it color them since the formula (day 1
blue,
day
2 red, day 3 green, day 4 blue, etc.) seems simple enough.

I've asked the same question in Word and don't know if Publisher would
be
any better.

Bonnie

 

[jam-acp]

I'm not sure if I'm understanding you correctly, but could you use the format
painter to quickly copy attributes from one day to another? If you double
click on it, it lets you click multiple times in your document to easily
change text that isn't all grouped together (like days of the week or titles
in a newsletter). It's still being done by hand, but it's a little quicker
than what it sounds like you're doing now.

Thanks anyway. I probably haven't explained it clearly. I only want to
change the color of the numbers, not the entire cell.

A shift consists of almost a dozen employees, so including their names won't
work. And, as I stated before, other things have to go into these cells and
line breaks with cells never worked real well for me.

I guess it's back to doing it by hand.

Again, thanks anyway.

Bonnie

http://support.microsoft.com/kb/268568
This tells you how to shade every other row in Excel. By tweaking the
numbers in the formula, you can tell it to shade every third row. If you use
a calendar template, that will help with the row height but it changes the
formula you'll need for the colors.

I have a feeling you are going to have a bit of work ahead of you. I would
be tempted to use a non-typical format. Maybe dates on the left side and
employee name across the top. Try posting in an Excel newsgroup - I'll bet
someone over there can help you. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

Could you give me a hint on how to do it in Excel? Plus, this is a
calendar
so other things go in the cell; holidays and such. Those should be in
black,
plus I have trouble doing line spacing inside Excel. Any easy fixes?

:

I would do that in Excel and use conditional formatting. No VBA required.
;-)

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


I'm not sure where to put this question.

I work for a fire department. We have three shifts. Every year, I
make
up
a 12 month calendar and go through and change the colors of the dates
to 3
colors (they work 24 on, 48 off, so one color for each shift). Is
there
ANY
way to do this easier? It seems like there should be a way to run a
small
program within Word to have it color them since the formula (day 1
blue,
day
2 red, day 3 green, day 4 blue, etc.) seems simple enough.

I've asked the same question in Word and don't know if Publisher would
be
any better.

Bonnie

 

[Mary Sauer]

You know, Jam, I should have thought of the Painter myself. Great suggestion.
Hopefully GoBonnieGo will see your post. Thanks for this.

--
Mary Sauer MSFT MVP
http://office.microsoft.com/

I'm not sure if I'm understanding you correctly, but could you use the format
painter to quickly copy attributes from one day to another? If you double
click on it, it lets you click multiple times in your document to easily
change text that isn't all grouped together (like days of the week or titles
in a newsletter). It's still being done by hand, but it's a little quicker
than what it sounds like you're doing now.

Thanks anyway. I probably haven't explained it clearly. I only want to
change the color of the numbers, not the entire cell.

A shift consists of almost a dozen employees, so including their names won't
work. And, as I stated before, other things have to go into these cells and
line breaks with cells never worked real well for me.

I guess it's back to doing it by hand.

Again, thanks anyway.

Bonnie

http://support.microsoft.com/kb/268568
This tells you how to shade every other row in Excel. By tweaking the
numbers in the formula, you can tell it to shade every third row. If you
use
a calendar template, that will help with the row height but it changes the
formula you'll need for the colors.

I have a feeling you are going to have a bit of work ahead of you. I would
be tempted to use a non-typical format. Maybe dates on the left side and
employee name across the top. Try posting in an Excel newsgroup - I'll bet
someone over there can help you. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


Could you give me a hint on how to do it in Excel? Plus, this is a
calendar
so other things go in the cell; holidays and such. Those should be in
black,
plus I have trouble doing line spacing inside Excel. Any easy fixes?

:

I would do that in Excel and use conditional formatting. No VBA
required.
;-)

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


I'm not sure where to put this question.

I work for a fire department. We have three shifts. Every year, I
make
up
a 12 month calendar and go through and change the colors of the dates
to 3
colors (they work 24 on, 48 off, so one color for each shift). Is
there
ANY
way to do this easier? It seems like there should be a way to run a
small
program within Word to have it color them since the formula (day 1
blue,
day
2 red, day 3 green, day 4 blue, etc.) seems simple enough.

I've asked the same question in Word and don't know if Publisher would
be
any better.

Bonnie

 

[jam-acp]

Well, this forum and you specifically have saved my butt on more than one
occasion. I hope my suggestion can help someone else in the future.