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.)

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.

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 »

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 »

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)