How To Import Colors unavailable in Excel

By default Excel provides a lot of colour options. But sometimes Microsoft releases templates having entirely new set of colours, generally as the heading colours.
If you want these colours to be added in your Excel sheet here is the trick:

1. Make sure that both the worksheets are open- the one in which you want colors to be added and the one from which you are importing colors.
2. Go to Tools » Options
3. Now go to the Color Tab which is above the first tab View
4. Look at bottom of this tab - There is drop down box "Copy Colors From". Click it, you will get the name of the file from which colors are to be imported(Book2.xls here in example)
5. Select the file and immediately you will observe that the non-standard colors have been added to your Color tab.
6. Press OK; Done