Return yellow with dates

[Alpacino]

Hi i have a problem with this. I am trying to create a formula that will determine if the date is greater than today or given range the answer will be yellow.
E.g
Today is 7 sept
I have these numbers
1. 4. 8. 12. 15.

Range is between 2sept to 27 sept
So I would like the result to happen

1. 4. 8. 12. 15.
White yellow. Yellow. White. White

Any ideas??

 

[Trevor G]

This isn't represented very well, can you copy part of your spreadsheet into your thread so someone can take a look. As you are stating dates but showing numbers with full stops !