Highlight Specific Numbers + more Excel tips
Excel Weekly News from Contextures March 17, 2015
Make it easy to spot numbers that are in another list -- use conditional formatting. See how it works, and find many more tips, in this week's Excel news.
- Debra - firstname.lastname@example.org
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
Here are a few of the Excel articles that I read recently, that you might find useful:
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
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.
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
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!
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.
Click the link to learn more about Excel University. And remember, until March 31, 2015, you can save 20% with this discount code: contextures2015
See more recommended Excel products.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2018
All rights reserved.