Those ranges are selected because, in MS Project, they are the Phases and/or Sub-Phases of the project. Those titles rarely change- I would say it is a slim to none chance that they do. In the very beignning as we were determining the timeline, yes, certain wording was altered- but the chance of me having to change something between now and the end of the Project, is very very slim.

So, that is what would determine how and when I will format the background color of a selected range of cells (based on the information provided in column C). So, as I provided in my example- cell C2 contains "Scope / Design". Therefore, cells A2:L2 should be formatted with the appropriate color I had chosen.