Microsoft Excel users, here’s a quick tip on adding a condition to a drop down list. You can use a Microsoft Excel drop down list to display a simple list, though sometimes you need a bit more control ...

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started. Spreadsheets usually hold a wealth of information, but it ...

Track your invoices, keep on top of your job search, and get the best value for money with these three easy-to-follow Excel projects.

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how. An expression to return a simple ...

Most people set up a dropdown list to make spreadsheets smarter with Excel's data validation. However, the Custom option in the Data Validation dialog accepts any formula that returns TRUE or FALSE, ...