Happy Thanksgiving

Less than a week from now (on Thursday) I'll be meeting with other family members, gathering around a common meal, and thanking God for the blessings we collectively enjoy.

Thursday is the official Thanksgiving holiday, and it is one we look forward to quite a bit in our family. It is a time when many memories are made together.

I hope that you have a great week and that you have the opportunity to reflect on the blessings you enjoy and that we often take for granted.

Happy Thanksgiving.


ExcelTips (ribbon) for 21 November 2015

Powerful spreadsheets
Can't Access the Registry

Many Windows applications rely on information stored in the Registry. If that information cannot be accessed, the application may not work as desired. Here's how to overcome a specific Registry-related problem with Excel VBA.

Read this tip »

(Thanks to David de Jongh for contributing to this tip.)

Conditional formatting
Shading Based on Odds and Evens

You can use conditional formatting to add shading to various cells in your worksheet. This tip shows how you can shade cells based on whether a value is odd or even.

Read this tip »

Making Sense of Times and Dates

One of Excel's great strengths is its ability to work with huge amounts of raw data. Two of the most common types of data stored in Excel are times and dates. Working with these special data types is not as easy as it may first seem. Check out ExcelTips: Times and Dates and learn the secrets of working with your times and dates.

Excel can calculate date in lightening time
Understanding Relative and Absolute Addressing

In Excel you can reference a cell in a formula by entering the coordinates for the cell you want to reference. This can affect how that formula is later copied to other cells. If you want to modify how Excel changes your cell references in formulas, you need to understand the difference between relative and absolute addressing.

Read this tip »

Identifying the Last Cell Changed in a Worksheet

When someone changes a cell in a worksheet, Excel normally goes along its merry way of keeping everything up to date. It does not, however, keep track of where that last change occurred. Here's some ideas on how you can determine the location of the last change by the user.

Read this tip »


Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

Modified Rounding

I need a formula that will round a value based on whether it is less than or equal to .25. So, for instance, 3.24 would round down to 3 and 3.25 (or greater) would round up to 4.
—Samantha Tutton (provide an answer for this Help Wanted question)

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 794  •  Orem, UT  84059  •  801-607-2035