Hello everyone.
I have a little problem. This is kind of excel sheet of cleaning table in factory. I made it with date function so when I open every month i get the list
of days (29,30,31 depend of month) and colored weekends.
Now I need to color in red every cell under Weekend from B8 to AF16, for example if now comes October, my weekends will be different from September and different cells needs to be colored red depending on color weekends.Sub test() Dim r As Range, c As Range Dim B8 As Range Set r = Range(Range("B7"), Range("AF7")) For Each c In r If Weekday(c) = 1 Or Weekday(c) = 7 Then c.Interior.ColorIndex = 3 End If Next c End Sub
Can you help me please.
Capture.jpg