please help me figure out the correct formula to show all these in Column D:
1. the cells in Column D should only return the # of days remaining if the status in Column B is listed in column F
2. the cells that will not return anything should appear blank
3. highlight the days in RED if they're >= 10days
please see attached file for reference
Bookmarks