I assume your calendar uses the Excel date values formatted as text.
These are serial values. You can set Conditional formatting on each
cell in your calendar using "Formula Is" and =MOD(B16,8)<4 (where B16
is the current cell; make sure it does not have $ in the cell
reference), then copy the format to the entire calendar.

If the dates don't line up with your work schedule, adjust it by adding
a fudge factor to the formula; i.e., =MOD((B16+1),8)<4 to move the
formatting by one day.

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=522867