how to conditional format rows based on dates in google sheets
IN SUMMARY
Conditional formatting in Google Sheets allows you to highlight entire rows based on dates in a specific column. You can use built-in rules or custom formulas to achieve this.
Using Built-in Rules
For example, if you want to format rows based on dates in column C, select the entire range from C2 to the last row you want to include.
In the Conditional formatting rules sidebar, select the desired rule from the drop-down menu. For example, choose 'Date is' and then select 'today' to highlight rows where the date in column C is today's date.
The built-in rules are limited in their functionality and may not cover all your requirements. In such cases, you can use custom formulas.
Using Custom Formulas
For example, if you want to format rows based on dates in column C, select the entire range from A2 to the last row and column you want to include (e.g., A2:H100).
In the Conditional formatting rules sidebar, select 'Custom formula is' from the drop-down menu. This will allow you to enter your own formula.
For example, to highlight the entire row if the date in column C is today, you can use the formula: =$C2=TODAY(). Replace C2 with the appropriate column and row reference for your data.
Examples of Custom Formulas
=AND($C2>TODAY(), $C2<=TODAY()+7)
=ISBETWEEN($C2, TODAY(), EDATE(TODAY(), 1), FALSE, TRUE)
=$C2<EDATE(TODAY(), -6)