Contextures News 20150317

Highlight Specific Numbers + more Excel tips

March 17, 2015

Make it easy to spot numbers that are in another list -- use conditional formatting. See how it works, 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.

Highlight Numbers

Highlight numbers that are found in another list, with Excel's conditional formatting This example uses lottery numbers, and you could use the same technique for other types of lists, such as names, or dates.

Read the details on my blog, and watch the video, to see how it works: Highlight Winning Lottery Numbers

Highlight Numbers

More Excel Tips

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

  • Aaron Souppouris takes a look at the new Office 2016 for Mac preview. He suggests that you try it, and warns you to "keep Office 2011 around for the important stuff."
  • Finally, for a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.

Excel Announcements

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

  • Amsterdam Excel Summit: Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year's summit was an outstanding success, and registration is now open, for this year's event.

Video: Move Pivot Table Values

Last week, someone emailed me to ask about the "Values" button that shows up in the field list, when you have more than one value. You can see an example in the screen shot below.

.Move Pivot Table Values

That button represents the group of Value fields, and you can move it to the Row area, for a different layout.

Click here to watch the short video that shows how the Values button works: Show Pivot Table Values Vertically

Goodbye Snowman!

It's finally getting a bit warmer, and the big piles of snow are melting. While we walked through the park last week, we saw this fallen snowman. That is a pretty good sign that spring is just around the corner. Sorry snowman, but I hope we don't see you again until next winter!

weekly photo

Featured Excel Product

This week, I'm pleased to recommend Excel University -- an online Excel training course designed specifically for accountants. I went through several of the modules, and was very impressed by the content, delivery, and course structure.

As an exclusive offer to Contextures Newsletter subscribers, you can save 20% with this discount code: contextures2015 (code expires March 31, 2015)

The course focuses specifically on the Excel features, functions, and techniques that are most useful to accounting professionals. The training is practical and the concepts are easily applied to your workbooks. You'll learn how to get your Excel tasks done more quickly, how to save time, and how to automate your recurring-use workbooks.


That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.


Last updated: January 25, 2020 4:36 PM