conditional formating to highlight current week?

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?
 
D

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
 
P

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top