From the course: Excel PivotTable Quick Tips
Join today to access over 25,300 courses taught by industry experts.
Remove conditional formatting from a PivotTable - Microsoft Excel Tutorial
From the course: Excel PivotTable Quick Tips
Remove conditional formatting from a PivotTable
- [Instructor] If you have cells that have formatting and you're not sure where it's coming from, for example, I can see this highlighting, but here on the Home Ribbon tab, I can see that there is no highlighting applied to these cells. It may have conditional formatting applied to it. Still on the home ribbon tab, click conditional formatting. You can either hover your mouse over clear rules or choose manage rules. This is going to show you what conditional formatting rules are on this pivot table currently, there may be more than one set of rules. To delete a rule, select it and click delete rule. Click okay, and the rule is gone.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.