conditional formating to highlight current week?

  • Thread starter Thread starter The Grinch
  • Start date Start date
T

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?
 
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
 
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..
 
Back
Top