Conditional formatting in multiple cell based on a singe cell

Hi!

This might be a very simple problem but the solution eludes me.

I'm trying to colour a set of cells in a row based on the value of a single cell value in that said row.
The user enters a specific week in this case (ex: 40), the table is filtered based on the week (40) and the week after (41).
The week after (41) is coloured in grey.

What I want is that the cells on the row where the week=41, should also be coloured in grey (C through G)

What I have now is:

 ActiveSheet.Range("B5").AutoFilter Field:=1, Criteria1:=WEEK, Operator:=xlOr, _
Criteria2:=(WEEK + 1)

With ActiveSheet.Range("$B:$B").FormatConditions _
 .Add(xlCellValue, xlEqual, "=" & WEEK + 1)
 With .Font
 .Bold = True
 .ColorIndex = 15
 End With
End With

Thanks in advance!
Macster