Showing posts with label spreadsheet. Show all posts
Showing posts with label spreadsheet. Show all posts

Monday, September 9, 2024

Google Spreadsheet conditional formatting for week days check (display weekends with a different color)

Goal: 

I have a column of dates that I want to format so that weekends are in a different color. 

Solution :  

conditional formatting and the formula =OR(WEEKDAY(A1)=7;WEEKDAY(A1)=1)