Excel Weekly News from Contextures September 16, 2014

Clear cells + more Excel tips

In this week's Excel news, you'll see how to automatically clear a cell, 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 -  ddalgleish@contextures.com

Macro Clears Dependent Cell

To help people enter data in a worksheet, you can set up drop down lists, where they can select items, instead of typing. It's also possible to make one drop down list dependent on what was selected in another drop down.

To prevent mismatched selections, you can use a macro to clear the dependent cell, when a new selection is made in the first cell.

Click here to see the details: Macro Clears Dependent Cell

Slicers for Conditional Formatting

I'd never thought about using Slicers to control conditional formatting, until I watched a short video by John Michaloudis, from My Excel Online. Instead of fussing with the settings, just click a Slicer button, to change the values.

John uses the technique with a pivot table, but you could also do this with regular cells on a dashboard. You could even use a Slicer to change values for a formula, for something like a budget or forecast.

Click here to watch the video, and download the sample file (scroll down to find the videos): 10.13 Control Conditional Formatting with Slicers

The video is from John's Xtreme Pivot Table course, which has more than 200 videos, along with practice workbooks, finance business cases, and 12 months of personal support. You can use the coupon code CONTEXTURES for a 10% discount.

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: Count Function Quirks

You can use Excel count functions to count cells with numbers only, count cells with any type of data or count blank cells. The video shows the COUNT function, COUNTA function, COUNTBLANK function

Wine for Excel Fans

Even if you don't drink wine, you might like the label, "The Formula", on this bottle -- it seems perfect for Excel fans.

I tested it last week, just for scientific purposes, and would definitely have it again.


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.