Formulaic conditional formatting rules in Microsoft Excel can be tricky, so learn how to avoid a common mistake.

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.

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