How to automatic row row in a colour based on cell value

Hi All,    I require some assistance on a problem. Please see below:    Context: Everyday a purchser supplies you with a new date for when a part will come into your fridge making factory. If th...