To create formula-based rules, select a range, use the “New Rule” option under “Conditional Formatting,” and input a formula with appropriate cell references.