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.

The Gauge chart is known as a dial or speedometer chart. Learn how to create a Gauge Chart in Microsoft Excel by following this tutorial.