Excel formula for changing rod based on cell colour

Hi all,    im trying to set up a qualification spreadsheet,    what I’d like to happen is when a specific date has passed in the next 3 years, for the row to go red and the cell on that row in th...