Color Scales are new in Excel 2010 and they highlight the smallest and largest data points within your Pivot Table.

It works like a heat map, in that it gives the highest number a shade of color and the lowest number a different shade of color, so your numbers can stand out at one glance.

DOWNLOAD WORKBOOK

ColorScales

HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Pivot Table Calculated Item Pivot Table Calculated Items allow you to do mathematical calculations with your Item List.  You can use any of the Excel mathematical equations, like /*+-%.The only limitation is that you cannot reference any cells.  Pivot Table Calculated Items can be used to calculate chan...
Show The Difference From Previous Months With Exce... Excel Pivot Tables have heaps of calculations under the SHOW VALUES AS option and one that gets the most use is the DIFFERENCE FROM calculation.You can show the values as the Difference From previous months, years, day etc.  This is just great when your boss asks you how you ...
Free Pivot Table Webinar Hey there,I have been having a huge response to this highly acclaimed Pivot Table webinar and will continue to give these lessons in to the new year!  If a date is not suitable for you, you can always come back to the Registration link below on a future date.  Happy Pivot...
5 Speedy Steps To An Excel Pivot Table! (infograph... G'day All,In this free downloadable Excel Pivot Table Cheat Sheet/Infographic, I show you how easy it is to create an Excel Pivot Table in 5 Speedy Steps...Enjoy and please comment below if you have any Excel or Pivot Table questions, I'm here to help you 🙂DOWNLOAD ...