How to change a cell colour depending on if another cell has the word Sun and or Sat

Hi All, I was wondering if you can help. I am trying to create a Team rota for a year in excel 2016. What I have done so far:
In cell B2 I am using the CalendarYear formula to show 2023. In Cell B9 I have a list of team members to cell B30. I have entered each day of the year starting in cell H8 to cell NI8. The months are in cell H7. I used the formula =TEXT(WEEKDAY(DATE(CalendarYear,1,H$8),1),"ddd") in cell H8 to display the days (Mon-Sun). What I am trying to do is have a formula or conditional formatting to change ever cell colour that has Sat and Sun in the range H8:NI30. As an example in January 2023, Sun 1st, I want the cells from H9 to H30 to be in a different colour and the same for 7th and 8th (Sat & Sun), etc.. I tried to goggle this but all i was getting was all the cells was in a different colour. Really hope that makes sense, any help will be truly appreciated.

Thank you, ArchieBook2.xlsx

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Select the range H8:NI30 so that you only need to do this once, then click on Conditional Formatting | New Rule | Use a formula... , then enter this formula in the dialogue box which pops up:

=LEFT($B8)="S"

then click on the Format button | Fill tab and choose the colour that you want for the weekends, then OK your way out. Excel will automatically adjust the cell reference to suit the selected range, so you should see your chosen colour applied to the weekend columns.

In future, it would help if you attached a sample Excel workbook, as Trevor has suggested.

Hope this helps.

Pete

EDIT: I've re-read your post, and it seems that the days of the week are in H8:NI8, with the data below. In that case, select the range H9:NI30 and use this formula:

=LEFT(H$8)="S"

Hope this helps.

Pete

By the way, thanks Trevor.

You're welcome