Can anyone help me edit this macro - colour change depending on date

Hi folks,

I currently have a spreadsheet that someone else setup for me a while ago and basically in column D i think theres a macro that changes the background of the cells in column D depending on the date. I think its setup at the minute so that when i enter a date its GREEN up until 2 weeks prior to that date. When it hits 2 weeks before that date it then turns orange and then when it actually hits that date it becomes overdue and therefore turns red.

What Id like it do do now is this please?.....

1 - Firstly I need to delete column C as i no longer need that.

2 - I enter a date (this is a date when a patients next prescription is due) and if the date i enter is more than 10 days BEFORE todays date I want it to change the cell bacground to green. In other words a black cell is white and as soon as i enter any date it turns green by defualt.

3 - When its 10 days prior to todays date i want to turn orange

4 - When its 5 days prior i want it to turn red

I'm sorry to be a pain, im sure its only a 10 second job if you know how to do macros but im totally clueless im afraid. Could someone spare me a few minutes to edit this spreadsjheet for me please? Would be appreciated. thank you