Auto color cells + more Excel tips

Excel Weekly News from Contextures September 30, 2014

In this week's Excel news, you'll see how to automatically color data entry cells, and much more. Thank you for reading the Excel news, and I hope that you are enjoying the Excel articles. If you have suggestions for future topics, please let me know.

 -  Debra -

Show Color With Conditional Formatting

On a data entry sheet, select a number of options from a drop down list. That number of options show up in the data entry area. Then, select a color for each item, from another drop down list. In the cell to the right, the selected color is shown..

Click here to see the details, and watch the video: Show Color With Conditional Formatting

Get Total from Specific Pivot Table

If you have multiple copies of a pivot table in a workbook, on different sheets, you can use the GETPIVOTDATA function to pull the total amount from a specific pivot table.

Click here to see the details, and watch the video: Get Total from Specific Pivot Table

New Project Manager Course

I've known Doug Hong online for a few years, and enjoy his Excel videos on YouTube (the DougH channel). Doug has just created a new online course -- Excel 2010 for the New Project Manager. The course is on the Udemy website, and the regular registration fee is $99.

Doug is giving my newsletter subscribers an exclusive coupon for free registration, if you sign up by October 7, 2014. If you take the course and find it helpful, please leave a review -- there is a review/feedback tool on the course's web page.

For details on the content, you can watch the course introduction video, before you register. The course covers the basics of Excel 2010, and some of the features that you'll need for project management.

Excel 2010 for the New Project Manager Course -- free registration link -- expires Oct 7, 2014

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel:

Video: Copy and Paste Problems

You can run into problems if you copy multiple ranges, and try to paste them to a new location. You might see an error, "That command cannot be used on multiple selections", or values might be pasted, instead of formulas.

See the steps for copying and pasting multiple selections in this short video tutorial.

Leaves of Many Colours

We went for a walk in a nearby conservation area on Friday, and the leaves are starting to change colours. The water in the small lake was very still, and made a perfect reflection of the trees. Soon, I'll have to bundle up to stand outside, so I'll enjoy this beautiful weather while it lasts.


Contextures Products

Save time with our "Done For You" Excel products.


Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.




Privacy Policy


Contextures Inc., Copyright ©2019
All rights reserved.