24  The New Rule dialogue box will open. If the rules outlined above do not cover what you need, you can create your own rule. To create your own rule: New Rule  3. Select  New Rule . 2. Select the  Conditional Formatting  tool. 1. Highlight the cells in your data range.