Eclipse Fever

It seems like everyone has "eclipse fever" lately, with a total eclipse passing over the continental US on Monday. Things seem especially fevered in our neck of the woods, since the path of the eclipse is going right over Wyoming. In our small town, the eclipse will reach 94.5% of totality, which should still be pretty dark.

We, however, will be traveling about 3 hours north and east of our town in order to get (hopefully) into the path of totality. I say "hopefully" because, as one might expect, we may run into restrictive traffic on Wyoming's limited road system and, as always, we are at the mercy of the weather.

—Allen
     

ExcelTips (ribbon) for 19 August 2017

Time formulas
Determining If a Date and Time is within Working Hours

Excel is great at working with times and dates. Sometimes, though, it can be a bit tricky to figure out how to work with both times and dates at the same time. This tip examines one situation in which checking both must occur.

Read this tip »

(Thanks to Michael Avidan (MVP), Phil Cook, Craig Korfanta, Steve Aprahamian, Ray Martin, Bob Beechey, Ira Bernstein, William Bland, Alan Cannon, Mike Shellito, Bob Hutchins, Les Landau, Brian Lair, Jacques Raubenheimer, Debbi McDaniel, Harold Druss, Harry Ruchti, Allen Cody, Peter Kirkpatrick, Eldhose Scaria, Ken Varley, Fred van der Meulen, Henry Arthur, Damian Fennelly, Prasanth Pottabathni, Scott Renz, Yvan Loranger, Bob Hall, Piers Morgan-Harvey, and Eva Balasa for contributing to this tip.)

 
Customizing Excel
Fixing the Decimal Point

Don't want to always type the decimal point as you enter information in a worksheet? If you are entering information that always has a certain number of digits after the decimal point, you can instruct Excel to always assume where the decimal point should be placed, even when you don't type one.

Read this tip »

 
Baffled by Array Formulas?

Have you heard about the special array formulas you can create in Excel? They make it a snap to perform calculations using large amounts of data and even generate results you can't get with regular formulas. Array formulas may be Excel's best-kept secret. Remove the confusion; discover how to use array formulas today.

 
Formulas
Understanding Operators

At the heart of working with Excel is the process of creating formulas that calculate results based on information within a worksheet. These formulas rely upon operators to do their work. Excel provides a number of different operators you can use, as outlined in this tip.

Read this tip »

 
Macros extend Excel
Debugging a Macro

Part of writing macros is to make sure they work as you expect. This involves a process known as debugging. Here's how you can make sure your macros are free of any errors that may crop up.

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.

 
Changing Typeface with Conditional Formatting

Conditional formatting is great at modifying the attributes of whatever text appears in a cell. However, I need a way to change the actual font using condtional formatting. (I cannot use a macro to do this.) Is there a way to actually change the typeface used in cell through conditional formatting?
—Nadim Daouk (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 1187  •  Mountain View, WY  82939  •  307-200-0450