So I'm making a spreadsheet based on dates. I want the cell to be filled with different colors based on when the date is 1 month away, 3 months away, and 6 months away. And then when it becomes 1 month away, 3 months away, or 6 months away, I want the color to automatically change. I'm not sure this is even possible, but any help would be much appreciated.