How to Highlight Saturday Sunday Row on Google Sheet

Here how to use conditional formatting refer to the date of your data, especially for weekend data. you can copy this formula:

=or(weekday($A1)=1,weekday($A1)=7)

#googlesheet #conditionalformatting #weekend #date

[RuhNezMay]

Thanks a lot! An alternative syntax for the syntax could be: =weekend($A1, 2)>=6, meaning that if the day number is 6 or 7, it'll format the range you've chosen

[lorenzo._.poletto]

works, but things start to bug a bit when you insert an empty line above or below in the range

[abhilashathackur]

All my cells got highlighted. I followed all the steps exactly. But why is it happening?

[alesandroalbert]

What if the date are in the columns, Sir?