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

Excel does not have a built-in feature to sum or count cells by color, but this can be achieved using three methods: Filtering with Subtotal, Name Manager with Helper Columns, or Custom VBA Functions.

Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.

Macros in Excel can perform functions like inserting pictures, copying data from one cell to another, etc. In order to write an effective macro to insert images in excel, you will need to use a loop.

You can use Microsoft Excel in dark mode to change elements of your spreadsheet to a darkened color palette.