I am pretty sure the solution exist in VBA but my problem is I have zero experience in coding so I would really appreciate it if someone could help me with this OR even better if no coding is needed and I just didn't know how to do it, that would be great as well. Thank you in advance for all help.
The Setup
I have a Column A with unlimited rows down (Training Procedures) Each Cell in Column B all the way down I have a drop down menu with 6 possible answers (Cancelled, Overdue, On Hold, Confirmed, Planned and Completed) Each Cell in Column B will turn a certain colour when I select one of the 6 options (I've done this via conditional formatting) Column C to Column ND are filled with dates
What I am trying to do
Lets say Cell A4 is Forklift Training, I do the drop down menu to select "Planned" and B4 turns Yellow. When I put "X" in Cell E4 for example I need E4 to show the "X" while turning the cell colour in E4 to the same colour what B4 is because when I change the drop down menu of B4 later on to "Completed" which will turn B4 to Green that E4 must now turn green also while still showing the "X". If for some reason I delete the "X" the cell must just return to normal blank colour.
I hoping someone here has a solution for me.
Thank you again