I have seen a few examples on how to create a color coded drop down in an excel spreadsheet.
An example of what to do can be seen here. http://stackoverflow.com/questions/12643522/excel-2007-drop-down-list-that-effects-the-cells-color-but-not-the-content.
Although I can apply a conditional formatting in one sheet, this doesn't work when the drop down can appear in multiple sheets. I have to copy and paste the conditional formatting into each and every sheet which can be hard to manage.
I was wondering if anyone knows how to enfore this color coding conditional formatting across multiple sheets?