Google Spreadsheet conditional formatting for week days check (display weekends with a different color) Sep 9, 2024 • cm 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)