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

How to Create a Drop-Down Box With Color. One way to streamline data entry is to create custom lists in Excel and use them to create drop-down lists in specified cells.

You can type codes in VBA Editor to change the cell colors in Excel. Learn how to change the cell background color with VBA Editor in Excel.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting. Data bars are a kind of conditional formatting, with the bar length based on the value of the ...

You can use Microsoft Excel in dark mode to change elements of your spreadsheet to a darkened color palette. You control the dark mode in the Account settings from the ribbon's File menu.