How to change an Excel conditional format on the fly

Microsoft

Conditional formatting is a flexible and powerful tool in Microsoft Excel, but you can’t change a condition without modifying the underlying rule. Don’t let that stop you—use an input cell. Here’s how.