Conditional Formatting- Color Change

Allison F
โญ
I am needing to add conditional formatting to my sheet to change the color of a row if it was added within the last 30 days. How do I do that?
Tags:
Answers
-
- Add the Created Column
- Add a Checkbox Column with a formula:
=IF((TODAY() - Created@row) <= 30, 1, 0)
- Add conditional formatting rule if column (from step #2) is checked