Excel formula for changing rod based on cell colour

Question

Hi all,&nbsp;&nbsp;im trying to set up a qualification spreadsheet,&nbsp;&nbsp;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.&nbsp;Any help much appreciated.&nbsp;cheers&nbsp;

nikolinode · Answer

RobH28&nbsp;How to conditional formatting based on date in Excel?Conditional formatting dates equal to/greater than/older than TODAYConditional formatting past datesConditional formatting future datesConditional formatting between two datesConditional formatting based on date in another column+&nbsp;Hope I was able to help you with these links.NikolinoDE

Forum Discussion

Excel formula for changing rod based on cell colour

Share

Resources