Pecoflyer - No relation between date range and drop-down list. The thought process is a team member selects status from the drop-down in column A and puts the date they checked the system in column C. Using the date the spreadsheet is opened cell A1(=Today()) and the date in column C I get a column B number of days since last check. Using one of the date ranges in column G cells and comparing it to the status in column A I get a color displayed in column D. As an example I select Operational in column A put a date in column C and I open the spreadsheet and it has been 12 days since the last system check I get yellow in Column D. TIA for the help.