Conditional Formatting Rules Do Not Work

Hi folks,

I’m hoping someone can point me in the right direction. Self taught novice, and I can’t for the life of me figure out why this conditional formatting isn’t working. I’m trying to make a training tracker that highlights past due training in red, less than one month out in orange, and less than 90 days out in yellow.
Column G is the date the training was given, column H’s formula is “=G+365”. The conditional formatting rules are “cell value < “today ()”” formatted to red, “cell value between “today ()+1 and today()+30” formatted to orange, and cell value between “today ()+31 and today()+90” formatted to yellow. Everything just turns red no matter what the date is. I’ve tried adjusting the order of the rules to see if that changes anything. I even added an additional rule “cell values > today () + 90”are formatted to white. Also, the workbook is formatted to be dates if that is useful info.
Thanks for any help!!