How to Set a Rule in Excel. You can use Microsoft Office Excel to set conditional formatting rules to handle complex scenarios without having to code all of the formulas yourself. This is useful ...