Highlight row if date is more than 30 days old

A.M.

Hi all,

I'm hoping to apply conditional formatting to highlight a row if we are more than 30 days of a date. I've tried to use formulas, but as our form responses come in they seem to skip any row that has a formula. Any ideas?

Thank you!

sharkasits

@A.M. you need to make it a column formula so that it is on every row. Are you trying to see if something is greater than 30 days old? If so I would set up a checkbox with a column formula and then the conditional formatting based on the check box. If you provide a little more details I might be able to help more.