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

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

Conditional formatting can also help track expenses with deadlines. You can create a rule that highlights an expense when its due date is fast approaching or overdue.