VBA - Highlight Worksheet Tab Based on Week Formula

[kocs]

Hi all,

I am creating new worksheets on a weekly bases in one excel file to keep track of work stuff.
As I need to refer back and forth between worksheets, I like to have a worksheet tab highlight itself if the week that the worksheet is created is the current week.

In my current worksheet, I have grid A1 using the formula =WEEKNUM(F1), where F1 has the date that the worksheet was created.

Is there a formula that looks at A1 and highlights the worksheet tab if the value in A1 falls within the current week?

For example,
Cell A1 using the formula =WEEKNUM(F1) will return the value of "26", and this week is week 26 of the year. Hence this worksheet tab will be highlighted in Red.

[Phuocam]

Try this:

Please Login or Register  to view this content.

[jindon]

Try

Please Login or Register  to view this content.

[kocs]

Thanks for the quick replies. I have a question, the codes can be pasted under "This Workbook" right?

[jindon]

Could be..... prefer to a standard module.