Conditional Formatting Based on Date Proximity

Conditional formatting can be used to draw your attention to certain cells based on what is within those cells. This tip explains how you can use conditional formatting to change the color of cells based upon how close a particular date is to today's date.

Read this tip »

Making All Occurrences Bold

Want to make instances of a given word or phrase bold throughout a worksheet? Here's a way you can make the change quickly.

Read this tip »

Formatting Made Powerful

Discover one of the foundational building blocks of Excel. Custom formats are the basis for all cell-level formatting in Excel, and you can master their use. Display your data exactly and precisely as you want.

Converting Time Notation to Decimal Notation

Want to convert an elapsed time, such as 8:37, to a decimal time, such as 8.62? If you know how Excel stores times internally, coming up with the conversion formula is a snap.

Read this tip »

Finding Unknown Links

There are several things to try when finding unknown links in Excel.

Read this tip »

I've been publishing ExcelTips for years. Decades, actually. The newsletter you are reading right now is for very old versions of Excel. I still publish it because I know that some people are still using very old versions of Excel. Most people, however, are using newer versions of the program. If you are are using a newer version of Excel (2007, 2010, 2013, 2016, 2019, 2021, or the version in Microsoft 365), then you should seriously consider changing to the version of the newsletter designed for you. You can do so by clicking this link.

Thanks for your support of ExcelTips, and I hope you enjoy whichever version of the newsletter you receive. If you have any questions, just let me know.