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 use wildcards with the XLOOKUP() function in Excel Your email has been sent Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible. Lookup functions ...

TL;DR Key Takeaways : Conditional formatting issues in Excel often arise from the use of relative references, leading to fragmented or duplicated rules when rows are inserted. The OFFSET function ...