Trying to change Row colours on field triggers - either date and or words

I am trying to change row colours depending of data from 2 cells - I have included an example attached basically I want
a row to change to red 5 days prior to an expiry date
a row to change to light green if the item is open
a row to change to grey if it is Cancelled or Closed