Conditional Formatting - Custom Formula - Text Contains

Question

I have dates in column B that include weekdays in the following format: DDD, MMM DD, YYY (For example, Sat, Jan 19, 2019).

I want each row to auto format to a specific background colour based on the weekday in column B:

• if B1 contains Sat I want row 1 to turn blue
• if B100 contains Sat I want row 100 to turn blue

I have tried using suggestions from these threads like regexmatch() and countif():

• Conditional formatting based on portion of text
• Finding partial texts in conditional formatting custom formula

But neither of these seem to work for me.

I am at a loss. Any help is appreciated.

Answer 1

• conditional formatting of whole row with a custom formula: =IF(LEFT($A1, 3)="Sat", 1, 0)

---

Answer 2

• create conditional formatting based on Text starts with like:

---