Hi StargateFan,
Maybe I am unclear to exactly what you want but it sounds like w/
year is in A1 depends on the color you want your header. So
2005 = Red
2006 = Blue
2007 = Green
etc
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 200
and select the color you want. I hope this is what your looking for.
Merry Christmas
Jaso
--
jt
-----------------------------------------------------------------------
jtp's Profile:
http://www.excelforum.com/member.php...fo&userid=2113
View this thread:
http://www.excelforum.com/showthread.php?threadid=49593