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 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.
That's it for this week! If you have any comments or questions, send me an email.
Last updated: January 25, 2020 4:36 PM