Conditional Formatting Depending on Day of the Week

I am working on a time card spreadsheet. Each day of the week has a column. The top cell says the day of the week, the cell below has the date, and the next cells below are blank to enter the punch in and punch out times.

I need conditional formatting to shade cells below any column for Saturday and Sunday. I have tried multiple things and gotten close, but I can't get the forumula exactly right. I'm new here so go easy on me.

I can give more details if they are important, just didn't want to make my first post too long. Thanks for your help.

Just out of curiosity..

Do the Saturday and Sunday Columns Move?
Or is Sunday Always in column A and Saturday Always in G (or something like that) ?

If they don't move, why bother with conditional formatting? Just format the columns by hand.


Maybe I missed something..

They do move. I am making a template time card, and when you enter in the month, it automatically fills out the days of the week and the dates. I recently started working here and everyone was filling out their time cards manually every 2 weeks, and I knew that excel could just do it automatically. When I showed my boss the new time card he wanted the weekends shaded, which wouldn't be that hard to shade them each time I made a new time card, but It's nicer to just have them shade automatically.

I see you marked the thread [Solved] ?

So you got it going then?

Alright I figured it out! Hopefully this thread will be helpful to someone in the future. I applied this conditional formatting to the table below the days of the week and the dates, =FIND("Saturday",C$8), for some reason I had to add a $ before the 8, when I put a $ before C, it only shaded one of the cells in the column I wanted shaded. I don't really understand why, if anyone wanted to explain that I would be curious. Hopefully i'm explaining clearly enough for this to make sense.

Okay so I'm not very good at explaining but I attached an example of what I ended up with. If you edit the month (needs to be the 15th day for the way I made it) then it will fill out the time card automatically. Feel free to look at it and give me any suggestions.

Look at the attached file.

I created a new condional rule in each worksheet. It's the first one.