Well, since I can't seem to get a complete answer, I'll try breaking i
up a bit. I guess my biggest question is how do I make the compariso
of a cells month (i.e. c.value = Month 3 or 4 or 5)?

With conditional formatting (which I do not want to use due to no
being able to reference the font for other stuff later on) I'd d
something like this:


Code
-------------------
=OR(MONTH(c.value)=3, MONTH(c.value)=4, MONTH(c.value)=5)
-------------------

However, I do not know how to format a similar If "month" check in VBA

--
BrianDP197
-----------------------------------------------------------------------
BrianDP1977's Profile: http://www.excelforum.com/member.php...fo&userid=2911
View this thread: http://www.excelforum.com/showthread.php?threadid=49064