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

Unlock the power of Excel conditional formatting! Learn tips, tricks, and advanced techniques for smarter data visualization and analysis.

This guide shows how to create progress bars in Excel using Bar Charts and Conditional Formatting on a Windows 11/10 PC. Take a look.

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.