Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

SmartArt is visually used to communicate information. We explain how to add and modify SmartArt diagrams in Microsoft Excel.

This is the demonstration file to accompany the article, How to add color to a drop-down list in Excel by Susan Harkins.

Learn how to create an automated data entry form in Excel with macros, interactive features, and secure design for efficient workflows.

Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight ...