In this post, we will show you how to change the default color, shape and font of a comment box in Excel. Microsoft Excel allows you to add comments to cells within worksheets. These comments could ...

Excel's conditional formatting tool applies formatting depending on cells' contents. Validation rules can change cells font, style, size or border. They can also change the text's color. For example, ...

Back in 2013 John Gagnon wrote a very popular post detailing some of his favourite Excel tips and tricks. We thought we’d update the list of classic shortcuts with a few that reflect some new ...

How to add color to a drop-down list in Excel Your email has been sent Color can be a powerful element in an Excel drop-down list, and it’s easier to add than you might think. Perhaps you want to use ...

If you use Excel on both the Mac and the PC, you’re probably aware that there are numerous differences between the two platforms’ keyboard shortcuts. Using the View -> Customize Toolbars & Menus menu ...

Can Excel sort by color? Absolutely. In addition to sorting by values, Excel can sort by cell color, font color, and cell icon. First, you must you must define the colors for your sort columns/fields.