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?

enter image description here

1 Answer 1


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.