Use two rules..

1. Cell value -- less than or equal to -- =TODAY()+1--format 'red'
2. Cell value -- greater than -- =(TODAY()+1)--format 'green'

Save your hair!