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.