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 ...
The Journal

Google Apps: Applying Conditional Formatting Across Sheets

For you advanced users who want to skip ahead: You apply the conditional formatting using a custom formula and some variation on the INDIRECT function. In addition to specifying the column and row, ...