Highlighting an Unchanging Value

If you need to determine whether a value, such as an average, has not changed in the previous seven days, the task can be challenging. This tip provides two approaches you can use to make short work of the task.

Read this tip »

(Thanks to James Woolley for contributing to this tip.)

Changing the Size of a Drawing Object

Add a drawing object to your worksheet, and at some point, you may want to change that object's size. You can easily change sizes by using the technique described in this tip.

Read this tip »

Enhance Your Excel Skills with Macros

Macros are a great way to increase your productivity with Excel by making the program work the way you want it to work. Discover the true power behind macros; ExcelTips: The Macros puts almost 800 pages of macro-focused information at your fingertips. Discover more...

Noting Inactivity within a Timeframe

There are many times when you are creating a worksheet that you need to analyze dates within that worksheet. Once such instance may be to figure out whether a certain date is outside some timeframe that you specify. This tip takes a look at how to accomplish such an analysis feat.

Read this tip »

Conditional Formats for Odd and Even Columns

Setting up conditional formatting can be challenging under some circumstances, but once set it can work great. Unless, of course, you start adding data to what you want analyzed in the formatting formulas and you want them automatically handled. This tip looks at a way you can get such automatic analysis.

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.

Determining Header Section Overlap in a Macro

I use a macro to create a page header, utilizing all sections of the header. In the sections I set the font size, but sometimes the desired size is too large based on the information I need to put in the section. Is there any way, in a macro, to determine if the header sections will overlap based on the text and the font size? If so, that would allow me to adjust font size within the macro to avoid any overlapping.
—Brian Dorey (provide an answer for this Help Wanted question)