Highlight Only Current Week Based on Date

[Kumara_faith]

Hi,

I have the table as attached.

The dates in row 3 represents the start date for the particular week of the month. I would like only the current week in row 4 to be highlighted based on the current date.

Example: If the current date is Nov 14 2010, then only cell C4 should be highlighted.


Is there a formula I could use in conditional formatting ?

I am using Excel 2007.

I have a cross post here:

http://www.mrexcel.com/forum/showthread.php?t=508924

[TMS]

The condition in B4 (and copy across) is:

=AND(TODAY()>=B$3,TODAY()<=B$3+7) ... format as required


Regards

[ConneXionLost]

1. Select range B4:F4 and go to Format > Conditional Formatting.

2. Enter as Formula is:

Please Login or Register  to view this content.

and set font/colours as required.

Cheers,

[arthurbr]

Connexion,

as Now() returns Date AND Time, it could yield uncorrect results depending on the hour the sheet is opened. TODAY is the way to go

[Kumara_faith]

Hi arthurbr/TMShucks/ConneXionLost

Thank you for your solutions and tips.

TMShucks - Your solution worked perfectly !

I have an additional requirement that I just realize needs to be incorporated.

Is it possible to modify the formula for conditional formatting to include a border around the column for the current week as attached ?

Appreciate your assistance and thank you in advance for your patience.

[TMS]

Yes, just select the borders tab when you are choosing your formatting options and add a border. You can click on any or all of the tabs and choose whatever options you need.

Regards

[Kumara_faith]

Hi TMShucks,

I did as instructed but it does not seems to be working. I have the attached the file here for your review.

Appreciate your assistance and thank you for your patience.

[martindwilson]

working ok when i look d4 is high-lighted as today is 17th and is in week beginning 15/11/2010

[Kumara_faith]

Hi Martin,

Yes, that part is working fine.

However, I would like the border of the column for the current week to be highlighted as well. In this case, the border for the column from d5 to d21 to be highlighted.

Appreciate your assistance.

[martindwilson]

well perhaps like this i have only 97 at the moment you may get more options with 2007

[TMS]

See attached


Regards