Hello all,
I receive information about planned projects (name of the project, start and end date, impact factor and strategy category), which are entered into an excel sheet.
A separate tab should show the project as a graph showing the duration over the year. The graph should change automatically whenever the start or end date is changed.
Ideally, the graph should also be displayed in the colour I assigned to each Strategy Category. Can I use conditional formatting between different tabs of an excel sheet?
Would that be possible in excel? I have attached an example which I have currently done manually.
Many thanks and kind regards,
Ines