I apologize. What I am trying to do is I have one sheet that shows the status of a project. The other sheet has the project phases and target dates on them. So, on Sheet 1 if the project named "Project X" in A2 is in the Planning Phase in F2 then I need the Status in G2 to show Red "No" if the it is past the target date which I know is TODAY()>="Target Date" or Status in G2 to show Green "Yes" if the it is before the target date which I know is TODAY()<="Target Date". The problem I am having is if I change the Phase in F2 to Implementation then I also need the Status in G2 to change to the corresponding Phase.