Conditional Formatting

5 lessons in order

Learn how to apply conditional formatting in Google Sheets based on another cell’s value using single or multiple formatting rules.

Highlight or format cells in Google Sheets based on another cell's text. Learn conditional formatting tricks & automation with Apps Script.

Learn how to copy conditional formatting in Google Sheets using Paint Format, Paste Special, and extending formatting to new ranges easily.

Learn how to apply conditional formatting with multiple conditions in Google Sheets using AND, OR, exact match, ranges, and text-based rules.

Learn how to use conditional formatting in Google Sheets to highlight dates within the past or next 7 days using TODAY, AND & helper columns.