Google Sheets Conditional Formatting for expiration dates

Question

I need help!

I need to create conditional formatting for expiration dates:

Cells should stay green

Cells should turn yellow when 1 month of exp. date

Cells should turn red once expired

Answer 1

• green: Date is after exact date =DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY()))
• yellow: Is between =TODAY() =DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY()))
• red: Less than =TODAY()

demo spreadsheet