On Sun, 25 Dec 2005 05:06:39 -0600, jtp
wrote:


Hi StargateFan,
Maybe I am unclear to exactly what you want but it sounds like w/e
year is in A1 depends on the color you want your header. So

2005 = Red
2006 = Blue
2007 = Green
etc

Yes, that's the concept.

Well highlight your header row(s) and open up conditional formating

Condition 1
Formula is -- -=$A$1=2005-
Then choose the color of your liking

Do the same for Condition 2 and 3. Except of course A1 = 2006 and 2007
and select the color you want. I hope this is what your looking for.

Yes, that's exactly the idea. Except the fact that to not make it
actual dates. i.e., when I leave this job, want to know that any year
they print - even after 2007 <g - each calendar will come out with a
different colour.

I guess that another option would be to have just two colours. All
odd-numbered years (i.e., 2005, 2007, 2009, 2011 ... down the road)
print in one colour and all even-numbered years in another. That
would be sort of a minimum solution to this. But I didn't find any
code to help in either type of situation in the archives.

See, if I just create conditional formatting for the 3 allowable
conditions, but only actual and specific dates, somewhere down the
road - in this example, in 2008 - user intervention will be required
to fix the coding. Well, they won't do it. Sure, it's highly
unlikely that this workbook will be used for years and years but I
never code or build anything with that as a guide. I make things with
the idea that they can be used "forever", just in case. You just
never know. Even if someone years later only even just adapts the
ideas and code to something else, it'll have served its purpose.
Meanwhile, it'll work for the foreseeable future and I personally have
a use for this calendar with some adaptations "forever". It'll
replace the necessity of my having to buy a date book every year,
something I've had to do every year since 1994! And want to leave it
ready-to-go with code that doesn't need any fixing later one.

Thanks so much!

Merry Christmas

Merry Christmas to you and yours, too! :oD

Getting together with family in early evening, so taking care of
finishing up the gifts this morning. <g

Jason