<div>
Check conditional formatting. There might be some rules setup that you may want to remove.
</div>


Check conditional formatting. There might be some rules setup that you may want to remove.

<div>
If all else fails, you can copy and paste the data to a new sheet and format that one.
</div>


If all else fails, you can copy and paste the data to a new sheet and format that one.

<div>
I found a solution, which says you need to make your data a table. Once you make it a table you can go to themes and then make the change.
</div>


I found a solution, which says you need to make your data a table. Once you make it a table you can go to themes and then make the change.

<div>
Hi Edward.<br />
The worksheet is not protected. &nbsp;I inherited the sheet from someone else.
</div>


Hi Edward.
The worksheet is not protected.  I inherited the sheet from someone else.

<div>
<div class="content wysiwyg-content">
I inherited a workbook that's very plain. &nbsp;Nothing. &nbsp;No graphics colors, etc.<br />
I want to apply themes but when I try to apply them nothing happens. &nbsp;No change in colors, fonts or anything. <br />
I have a feeling a predecessor modified a style or something.<br />
How can I reset the formatting of this sheet so that themes WILL take effect?
</div>
</div>


I inherited a workbook that's very plain.  Nothing.  No graphics colors, etc.
I want to apply themes but when I try to apply them nothing happens.  No change in colors, fonts or anything. 
I have a feeling a predecessor modified a style or something.
How can I reset the formatting of this sheet so that themes WILL take effect?

Excel 2010 - Themes are not changing anything!

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.