How-To Geek on MSN

I replaced several Excel formatting tools with a single hidden feature

One custom format field can scale numbers, add icons, apply color rules, and clean up visual clutter instantly.
Excel Dictionary on MSN

How to create color-coded dropdowns in Excel

In this video, you'll learn how to create dynamic, color-coded dropdown menus in Excel that automatically highlight cells a certain color depending on the value selected. First, we'll cover how to ...