Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.

How to Format a Row Based on the Value of a Cell in Excel 2007. Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might ...