conditional formating to highlight current week?

[The Grinch]

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?

 

[Don Guillett]

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

 

[Peo Sjoblom]

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..