Brandon
Reputation: 117
How to conditional Format based off of the day of the week?
I am having trouble figuring out how to conditional format based on the day of the week. Is there a formula that is known to work?
Upvotes: 0
Views: 100
Answers (1)
MattKing
Reputation: 7783
=TEXT(TODAY(),"dddd")="Monday"
should work for what you're doing.
Upvotes: 2
Related Questions
- Conditionally format all the cells with dates of the current week
- Highlight the working days using conditional format
- How to highlight a cell containing the name of a weekday in a row based on =Today() in Google Sheets
- How do I highlight cells based on the day of the week in Google Sheets?
- Excel: How to color the weekends with concatenated date and conditional formating
- Excel - how to get if a date is a specific day of the week?
- Conditional Formatting using dates and weekends
- Highlighting columns based on day of week
- Conditional Formatting to highlight weekends
- Tricky Conditional Formatting Involving Actual Values vs. Displayed Values