How To Reference Another Sheet in Conditional Formatting

Reference Another Sheet in Conditional Formatting It's Possible! This is just a "unique quirk" in Google Sheets related to conditional formatting. How to modify the conditional formatting to highlight different days as weekends using the Indirect formula to get a reference from another sheet. Another tab! 00:00 Introduction to a Google Sheets Quirk 00:09 Overview of Big Year Calendar 00:48 Different Versions of the Calendar 01:11 Customizing Weekends in Google Sheets 02:09 Conditional Formatting with Settings Page 03:08 Using the INDIRECT Formula 03:47 Testing and Final Adjustments 04:28 Conclusion and Further Resources