Excel 3-color scale based on dynamic data

Hi,   I have a spreadsheet that includes a date column.  What I would like is to figure out a way to use Excel's 3 color scale so the date furthest back is shaded color 1, today is color 2, and the...