Hi
Let A1 hold the date for the start of the year, as far as you are
concerned for Week numbering e.g. 02/01/2006 (2nd Jan 2006)
Let B1 hold =TODAY()
Let A2::G2 hold your week numbers 1 through 7

Mark A2:G2
FormatConditional FormattingFormula is
=AND($B$1$A$1+(A2-1)*7,$B$1<$A$1+A2*7)
Choose Format as required.


--
Regards

Roger Govier



Jaydubs wrote:
Hello Excel(lent) users,

I am looking for a way to indicate whether a certain day falls in a
certain week.

I have a header of week numbers from 1 till 7. In a certain
(undifened) cell i have noted =today(). Now I want the particular
week to be highlited if the day of today falls in that week. Anybody
cares to help?

Thanks !!
--
** Fool on the hill **