Excel formula for changing rod based on cell colour

Copper Contributor

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 the qualification colour to change to expired, id also like the row and cell to be green and say passed if it has not reached that date. 

Any help much appreciated. 


1 Reply