In Google Sheets, what would a script look like that would identify days of the week (i.e., Monday, Wednesday, Friday) and then change the background color of the corresponding cells?
Google-sheets – Format day of the week
google sheets
Related Topic
- Google-sheets – How to get the date of Monday and Friday of last week
- Google-sheets – Convert cell containing days of the week in first-letter format to day names in Google Sheets
- Google-sheets – How to set Monday as start day of the week in Google Sheets date picker
- Google-sheets – How to determine which working day of the month today is
- Google Sheets Formulas – How to Show Current Day of the Week
- Google-sheets – How to show Day of Week in Order by Day of Week in Google Sheets
- Google Sheets Script – Copy and Paste Data Based on Current Week Date
- Google-sheets – Next 5 working dates
Best Answer
Can be achieved with Conditional formatting (one rule per colour) where the data is dates:
or if text, with Text contains
sunday
....saturday
.