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?
-
1What's the cell content? Just 'monday', 'wednesday', 'friday', etc?– Franck DernoncourtCommented Jul 22, 2014 at 20:37
Add a comment
|
1 Answer
Can be achieved with Conditional formatting (one rule per colour) where the data is dates:
or if text, with Text contains sunday .... saturday.
