I am working on multiple projects with different start dates. I would like to create the color coding if it approaches the deadline. Sample data is given below for your reference.
Column A Column B Column C Column D
Project Name Project Start Date First Deliverable Date Alert
A 01/09/2018 Post 30 Working Days from Project Start Date Color Green, if >15 working days are remaining, Yellow, if >7 working days are remaining and Red, if <=7 Days are remaining.