Conditional Formatting begins with

[shaftdx]

I am making a list of absent employees. Basically I have a column of dates then the employee and who covered (some other things too that do not really matter for this)
What I want to happen is every time Monday appears for it to be a certain color. same for the rest of the week. If I do "Starts with" it will just be that cell. I want the whole row.

Is there a formula that I can include Begins with? if I use: =$a1="Monday" it will not work because the date is formatted as Monday, December 20, 2021

 

[Fluff]

How about

=WEEKDAY($A1,2)=1

 

[shaftdx]

How about

=WEEKDAY($A1,2)=1

Beautiful! Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.