Conditional formatting is a great feature for making the data in your worksheets more understandable and usable. What if you need to define a conditional format that has more than three conditions? Here are a few ideas.
Windows Explorer is a great way to browse through the files available on your system. If you see a document file you want to open in Word, you can normally double-click the file. If that doesn't work, then you'll want to try the technique described here.
Don't like the toolbar button images in your version of Excel? Don't fret; you can pull up the button editor and make changes pixel by pixel, if desired. (It's easier to do than you think, although you artistic talents may be tested in the process.)
The F8 key is a shortcut that allows you to turn on Word's extend mode. This mode is used to "extend" the text being selected. It is not the only way to select text, but it offers benefits that other selection methods do not offer. Here is one of the handy benefits of using the extend mode.
Using a formula to find information in a text value is easy. Using a formula to find either of two text values within a larger text value is a bit harder. This tip examines different formulas you can use to figure out how many cells in a range contain either of two text values.
One of the properties you can specify for a document is a subject. You can then use a field code to insert this subject, dynamically, into your document. This tip explains how to access the subject in your documents.
If your workbook contains links, you are normally given the opportunity to update those links when you open the workbook. When opening the workbook from within a macro, you probably don't want Excel to ask about updating the links. Here's how to stop Excel's normally inquisitive nature.
Read this ExcelTip: Updating Automatically When Opening Under Macro Control
Microsoft Excel Tips - Learn Excel Faster!
The Equation Editor is a great tool that allows you to add equations to your document. You have quite a bit of control over how those equations appear, including the ability to set the space between the numerator and denominator (if your equation has such). Here's how.