Conditional Formatting Help

[ChrisFoster]

Hi all,

I have a simple sheet that contains rota information.
In UK format I have the week commencing dates (Mondays) in column A, then staff names in B:D (as below).

What formula can I use in conditional formatting to highlight that we are in the current week? So for example, this week the row highlighted would be 17/10/2022, but when I open the tracker on Monday of next week it will highlight 24/10/2022?

Date	Advisor 1	Advisor 2	Lead Gen
03/10/2022	Cameron	Sam	Eloise
10/10/2022	James	Lauren	Tom
17/10/2022	Steve	Ness	Jodie
24/10/2022	Cameron	Wasim	Eloise
31/10/2022	James	Lauren	Tom
07/11/2022	Steve	Ness	Jodie
14/11/2022	Khurram	Sam	Yusuf
21/11/2022	Cameron	Wasim	Eloise
28/11/2022	James	Lauren	Tom
05/12/2022	Steve	Ness	Jodie
12/12/2022	Khurram	Sam	Yusuf

Kind Regards,

Chris

 

[Fluff]

How about

=$A2=WORKDAY.INTL(TODAY()+1,-1,"0111111")

 

[ChrisFoster]

Great thanks for that. It nearly worked, I just needed to change the '$A2' to '$A1' as below, it's working perfectly now. Thanks alot.

=$A1=WORKDAY.INTL(TODAY()+1,-1,"0111111")

 

[Fluff]

Glad to help & thanks for the feedback.