I am trying to apply conditional formatting that if a project is past its deadline the cell shows red (got that part). My question is can I apply conditional formatting to make the same cell green if in the “progress” column for each respective project it shows “delivered”. Thank you