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.

Automating the selection process isn't difficult if you rely on VBA's InputBox in Microsoft Excel.