Pivot Table Conditional Formatting
April 23, 2013
Show running totals in a worksheet, fix conditional formatting in a pivot table, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
Will spring ever arrive? I'd like to get my garden started, and set up a spreadsheet to keep track of what has been planted. The birds look a bit chilly too, like the little yellow finch that you can see in my photo at the end of the newsletter.
If you use conditional formatting in a pivot table, it might not update correctly, if you add new data or change the layout.
There is a setting that you can change, to ensure that the formatting automatically adjusts.
To see the details, and a short video, click here: Pivot Table Conditional Formatting
Instead of showing an overall total, you can create a running total on a worksheet, by using the SUM function in each row.
To see the details, and a short video, click here: Create a Running Total in an Excel Column
In this Excel file from Jim Cone, you can click the up/down arrows to rotate a list of items on an Excel sheet. For example, if January is at the top of the list, one click moves February up, and January rotates to the bottom of the list.
Click here, to read the details, and to download the sample file: Click to Move Excel List Items Up or Down
It's a good idea to use named cells in your worksheets. You can use names in formulas, and quickly select a named range.
This video shows you a quick way to create several names with a single click, by using the labels that you typed in worksheet cells. For more on naming ranges, please visit the Excel Names page on my Contextures website.
For a limited time, Mynda Treacy from My Online training Hub is opening her Excel Dashboard course, and if you sign up by 8 pm Pacific time on May 1st, you can get the course for 20% off. Use the Discount code: DASH
The course is video based, delivered online and is available 24/7. You'll receive comprehensive workbooks and sample dashboards to keep, and there's even an option to download the videos.
The previous classes were very successful, and you can read the glowing reviews from the students, who loved all the techniques that they learned in the course, and are using them to impress their colleagues.
Click here to find out find out details of the course, read the student comments, and watch the 'behind the scenes' video that shows you what you'll receive as a member.
Remember, if you sign up by May 1st, you can get the dashboard course for 20% off. Use the Discount code: DASH
Save time with our "Done For You" Excel products.
It's still a bit cold, but a few more birds are starting to appear, like this little yellow finch. He was sitting in a tree in front of our house last Friday, and it was easy to spot his bright feathers.
That's it for this week! If you have any comments or questions, send me an email.
NOTE: For the online version, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2013/20130423n9oqK.html
I'll also post any article updates or corrections there.
Last updated: October 28, 2018 9:42 AM