Question: how do you create a rule on excel?
Answer: Select the desired cells for the conditional formatting rule. ... 
From the Home tab, click the Conditional Formatting command. ... 
Hover the mouse over the desired conditional formatting type, then select the desired rule from the menu that appears. ... 
A dialog box will appear.