I wanted to conditionally format all Mondays in a date range. I found no way to do this with conditional formatting and filters, but at least I found a workaround.

In a column, next to the table I have, I used this formula:

=IF(WEEKDAY(Table1[[#This Row];[Datum]])=2;”Monday”;”Not Monday”)

I copied this formula to the other cells and then I filtered that specific column for Mondays and colored the background of those cells manually. This method does obviously not work so well if you have a lot of data, but formatting a few rows where dates are not changing should at least be quicker than manually going through each date.

You could also use something like this:

=IF(WEEKDAY(A1)=2;”Monday”;”Not Monday”)

The weekdays have the following numbering:

Sunday = 1
Monday = 2
Tuesday = 3
Wednesday = 4
Thursday = 5
Friday = 6
Saturday = 7