Hi,

I have a row of week beginings (mondays) for the year and i want to use
condition formating to change the format of the cell that contains the
current week. something like...

if cell value is between today()-6 and today() then special format

however i cant get it to work, i have days where two weeks are
formatted?

any ideas?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

From a Norman Harker post
With date in A1
In B1 use =WEEKNUM(A1,1)
Conditional format for A1
Formula is =INT(B1/2)=B1/2
46.00
10-Nov


--
Don Guillett
SalesAid Software
(E-Mail Removed)
"The Grinch" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Hi,
>
> I have a row of week beginings (mondays) for the year and i want to use
> condition formating to change the format of the cell that contains the
> current week. something like...
>
> if cell value is between today()-6 and today() then special format
>
> however i cant get it to work, i have days where two weeks are
> formatted?
>
> any ideas?
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>

Select the row with the week beginnings, assume it starts in A2, select from
A2 across so A2 stays white while the rest of the selection stays blue. do
format conditional formatting, formula is and in the formula box put

=(A2+6>=TODAY())*(TODAY()>=A2)

click the format button and select blue or red fonts or something like that,
click OK twice..

--

Regards,

Peo Sjoblom


"The Grinch" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Hi,
>
> I have a row of week beginings (mondays) for the year and i want to use
> condition formating to change the format of the cell that contains the
> current week. something like...
>
> if cell value is between today()-6 and today() then special format
>
> however i cant get it to work, i have days where two weeks are
> formatted?
>
> any ideas?
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>