Insert shape based on cell text

[TibiBenyi]

Hello Everyone,

I am trying to make a excell where I have different activities spread out on a time plan,

The idea behind the excel is if you imput a date in activity A then that activity name will show in the left table which is spread out on calendar weeks,
below each row i have set up an arrow to indicate the time frame
what i want to obtain is if i imput the date for activity A then a shape specific to that activity will show up in the cell below it on that arrow.

eg:
activity :
Project kick off
input date:
CW 12 2020
output:
in cell with CW 12 : the text "Project kickoff" is displayed
cell below it: " Yellow filled square shape"

Can that be obtained thorough conditional formating? Or is it a VBA type thing?

I tried to be as descriptive as possible, thank you for your help.

 

[Puertorekinsam]

If you want to always be entering in the same cell and have the result occur in a table, while not losing what was already entered, you will need to do it with VBA.