Spreadsheet: 181525d1348064656-how-do-you-make-cells-change-color-as-the-indicated-date-come-closer-conditionalformatting
Sheet: Sheet1

NAME | EXPIRES
[NAME] | 2012-11-23 00:00:00 |  | <----- From here down should be RED
[NAME] | 2012-12-02 00:00:00
[NAME] | 2012-12-08 00:00:00
[NAME] | 2012-12-21 00:00:00
[NAME] | 2012-12-31 00:00:00 |  | <----- From here down should be YELLOW
[NAME] | 2013-01-01 00:00:00
[NAME] | 2013-01-11 00:00:00
[NAME] | 2013-02-17 00:00:00
[NAME] | 2013-03-11 00:00:00
[NAME] | 2013-03-15 00:00:00
[NAME] | 2013-03-21 00:00:00
[NAME] | 2013-04-11 00:00:00
[NAME] | 2013-04-15 00:00:00
[NAME] | 2013-04-19 00:00:00
[NAME] | 2013-04-27 00:00:00
[NAME] | 2013-05-12 00:00:00
[NAME] | 2013-05-26 00:00:00
[NAME] | 2013-06-20 00:00:00
[NAME] | 2013-06-22 00:00:00
[NAME] | 2013-06-28 00:00:00
[NAME] | 2013-07-06 00:00:00
[NAME] | 2013-07-13 00:00:00
[NAME] | 2013-07-24 00:00:00
[NAME] | 2013-07-27 00:00:00
[NAME] | 2013-08-03 00:00:00
[NAME] | 2013-08-21 00:00:00
[NAME] | 2013-08-24 00:00:00
[NAME] | 2013-08-27 00:00:00
[NAME] | 2013-09-08 00:00:00
[NAME] | 2013-09-20 00:00:00 |  | <----- From here down should be no color
[NAME] | 2013-09-22 00:00:00
[NAME] | 2013-09-30 00:00:00
[NAME] | 2013-10-04 00:00:00
[NAME] | 2013-10-10 00:00:00
[NAME] | 2013-10-18 00:00:00
[NAME] | 2013-11-02 00:00:00
[NAME] | 2013-11-08 00:00:00
[NAME] | 2013-11-09 00:00:00
[NAME] | 2013-11-09 00:00:00
[NAME] | 2013-11-16 00:00:00
[NAME] | 2013-11-17 00:00:00
[NAME] | 2013-11-18 00:00:00
[NAME] | 2013-11-22 00:00:00
[NAME] | 2013-11-23 00:00:00
[NAME] | 2013-11-23 00:00:00
[NAME] | 2013-11-28 00:00:00
[NAME] | 2013-11-29 00:00:00
[NAME] | 2013-12-09 00:00:00
[NAME] | 2013-12-09 00:00:00
[NAME] | 2013-12-13 00:00:00
[NAME] | 2013-12-17 00:00:00
[NAME] | 2013-12-20 00:00:00
[NAME] | 2013-12-28 00:00:00
[NAME] | 2013-12-30 00:00:00
[NAME] | 2014-01-14 00:00:00
[NAME] | 2014-02-17 00:00:00
[NAME] | 2014-02-26 00:00:00
[NAME] | 2014-03-02 00:00:00
[NAME] | 2014-03-17 00:00:00
[NAME] | 2014-03-19 00:00:00
[NAME] | 2014-03-22 00:00:00
[NAME] | 2014-03-24 00:00:00
[NAME] | 2014-03-25 00:00:00
[NAME] | 2014-04-13 00:00:00
[NAME] | 2014-05-18 00:00:00
[NAME] | 2014-06-09 00:00:00
[NAME] | 2014-07-07 00:00:00
[NAME] | 2014-08-01 00:00:00
[NAME] | 2014-08-07 00:00:00
[NAME] | 2014-08-17 00:00:00
[NAME] | 2014-08-19 00:00:00
[NAME] | 2014-08-30 00:00:00 |  | 90
[NAME] | 2014-08-31 00:00:00 |  | 365
[NAME] | 2014-09-07 00:00:00
[NAME] | 2014-09-15 00:00:00
[NAME] | 2014-10-09 00:00:00
[NAME] | 2014-10-10 00:00:00
[NAME] | 2014-10-31 00:00:00
[NAME] | 2014-10-31 00:00:00
[NAME] | 2014-11-08 00:00:00
[NAME] | 2014-11-15 00:00:00
[NAME] | 2014-11-15 00:00:00
[NAME] | 2014-11-30 00:00:00
[NAME] | 2014-12-21 00:00:00
[NAME] | 2014-12-27 00:00:00
[NAME] | 2015-01-04 00:00:00
[NAME] | 2015-01-09 00:00:00
[NAME] | 2015-01-19 00:00:00
[NAME] | 2015-02-01 00:00:00
[NAME] | 2015-02-04 00:00:00
[NAME] | 2015-03-02 00:00:00
[NAME] | 2015-03-07 00:00:00
[NAME] | 2015-03-07 00:00:00
[NAME] | 2015-03-09 00:00:00
[NAME] | 2015-03-18 00:00:00
[NAME] | 2015-04-02 00:00:00
[NAME] | 2015-04-07 00:00:00
[NAME] | 2015-04-22 00:00:00
[NAME] | 2015-04-24 00:00:00
[NAME] | 2015-05-10 00:00:00
[NAME] | 2015-05-10 00:00:00
[NAME] | 2015-06-30 00:00:00
[NAME] | 2015-08-01 00:00:00
[NAME] | 2015-09-22 00:00:00
[NAME] | 2015-10-20 00:00:00
[NAME] | 2015-11-10 00:00:00
[NAME] | 2015-11-30 00:00:00
[NAME] | 2015-12-02 00:00:00
[NAME] | 2015-12-18 00:00:00
[NAME] | 2016-02-09 00:00:00
[NAME] | 2016-03-18 00:00:00
[NAME] | 2016-04-30 00:00:00
[NAME] | 2016-06-13 00:00:00
[NAME] | 2016-07-31 00:00:00
[NAME] | 2016-08-30 00:00:00
[NAME] | 2016-09-30 00:00:00
[NAME] | 2016-10-26 00:00:00
[NAME] | 2016-11-07 00:00:00
[NAME] | 2017-08-31 00:00:00
[NAME] | 2018-04-22 00:00:00
[NAME] | 2018-05-15 00:00:00
[NAME] | 2018-07-31 00:00:00
[NAME] | 2020-02-28 00:00:00
[NAME] | 2020-05-31 00:00:00
[NAME] | 2020-11-30 00:00:00
[NAME] | 2021-06-30 00:00:00
[NAME] | 2021-11-24 00:00:00
[NAME] | 2022-05-31 00:00:00
[NAME] | 2023-02-28 00:00:00
[NAME] | 2024-01-31 00:00:00