I am a beginner at more complicated functions in excel, so I hope my needs and explanations are adequate.
I am trying to create a school curriculum mapping tool where data (teaching objectives) from several sources (Criteria sheets) are compiled into a summary sheet.
Teachers will link (paste link?) several teaching objectives into a summary sheet.
The complex part of the requirement is to show teachers whenever an objective has been used already by colouring the text (conditional formatting?) on the source sheet.
I attach a model excel file which I hope shows the functionality of what I am trying to achieve, using simplified requirements. It depicts book or comic strip summaries that must choose setting/characters/page numbers or strip cell format based on fixed options. Whenever the summary sheet uses data from a source sheet, the data cell should change colour so other users can see it has been taken. Data cells can be used more than once.
While I can get simple conditional formatting to work, one-cell to another .. I do not know which functions/programming are efficient to achieve my goal across all source sheets.
Any and all help appreciated