Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

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?

share|improve this question
Since excel doesn't handle 3D references very well (you can't reference the same cell in an array of sheets) I think you need to have seperate conditional formatting. If its all the same cell the easiest way would be format one sheet. Select the cell(s) you want to copy. Select all the sheets together and paste format into the cell you want which will also copy the conditional formatting. – gtwebb Jun 3 '14 at 18:17
You can't enforce a rule across sheets, but you could write a macro that applies the rule to each sheet.. – Raystafarian Jun 4 '14 at 13:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.