Conditionally format all the cells with dates of the current week

Viewed 16

I have a table that looks like this:

some text    14.09.2022
some text    15.09.2022
some text    23.10.2022

And I need to conditionally format each cell in the second column if the date in that cell is during the current week.

I have tried different solutions from the Internet[^1], but neither works for me: each time Google Sheets says my formulas are wrong. Any help?

[^1]: For example, I have tried to adopt the formula found here.

1 Answers

Try below custom formula in CF rule.

=WEEKNUM($C2)=WEEKNUM(TODAY())

enter image description here

Related