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
SatI want row 1 to turn blue
- if B100 contains
SatI want row 100 to turn blue
I have tried using suggestions from these threads like
- 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.