Currently hardcoding the date to apply conditional formatting. Is there a way to do this based on a variable range of the last 30 days?
Google Sheets – Format Cells if Date is Within Last 30 Days
conditional formattinggoogle sheets
Related Topic
- How to Highlight Cells with Formulas in Google Sheets
- Google-sheets – Highlight a cell if the date in one column is the latest date
- Google-sheets – Conditional formatting over wide area of cells, referencing other cells
- Google Sheets – Conditional Format Formula for Previous Cell Content
- Google Sheets – Conditional Formatting Based on Date Within Text String
- Google-sheets – Conditional Formatting color if today minus cell date is more than 90 days
- Applying Conditional Formatting Color Scale to Non-Numerical Cells in Google Sheets
- Google Sheets – Conditional Formatting for Last 24 Hours
Best Answer
From the first menu select 'Date is' and from the second select 'in the last month'
However that will not highlight future dates and may not be what you want
In that case replace '2018-02-27' with
=now()-30