I need to put the traffic signal lights based on the project health. One column will have the Project start date and another column will have the project phase(Phase 1, Phase 2, Phase 3). Each phase will have 3 weeks time for green signal. 1 Week additional time for yellow signal. Then Red signal.
For example
Project 1 : Phase 1 is under 3 weeks then the signal light will be green
Project 2: Phase 1 is over 3 weeks but under 4 weeks. So the signal will be yellow
Project 3: Phase 1 is over 4 weeks. The signal will be Red.
Please advise if this is possible to do using conditional formatting. or VBA coding is needed.
Thank you for your comments.
Regards,
KRA