Help with conditional formatting

Hi all,

I am trying to set up conditional formatting on a table of mine, please see screenshot below:

The table shows a target date, and a column which shows the amount of days between today and the target date.

I am trying to get the conditional formatting to behave as follows:

less than 100 days = red

101-365 = blue

366 +  = green

As you can see from the screenshot I have the rules set up to reflect this, but when I click ok on the formatting box, nothing is changing (the majority should change to blue, and one should change to green, but instead everything is just staying as is)

Any tips or help would be greatly appreciated.

Thanks,

DRJ