I have a sheet with expiration dates entered in a column of cells. I need
the conditional formatting to automatically change the background color of
those cells to help identify expired dates. I need the colors to change from
green, which is more than 14 days in the future, to yellow, which is between
1 and 14 days out, to red which would be the current date or a past date to
indicate expiration. Can this be done and how?

I used contional formatting as follows:
Condition 1-Cell is less than="today()" Pattern is Green
Condition 2-Cell is between="today()" and "today()+14" Pattern is Yellow
Condition 3-Cell is greater than="today()+14" Pattern is Red

Please help,
Thanks, Chris