In your Excel sheet, go to Home > Conditional Formatting > Manage Rules. Next to Show formatting rules for, click the drop-down menu to select This Worksheet or a specific sheet.

That’s where Excel’s conditional formatting with formulas comes in, offering a way to transform your data into a dynamic, visually intuitive tool.

Head to Excel Home -> Conditional Formatting. Expand Icon sets and pick a relevant set for your Priority column (arrows pointing up for high priority, sideways for medium, down for low).

Excel offers several built-in conditional formatting rules you can apply to your data. (Click image to enlarge it.) We’ll demonstrate using Excel for Windows under a Microsoft 365 subscription.

Learn how to fix Excel conditional formatting issues with dynamic references, OFFSET function, and defined name method for ...

Conditional formatting is powerful, but you can avoid frustration by learning how and when Excel evaluates rules. The interface isn’t particularly intuitive, but it does allow you to edit rules ...

The article, Use a custom format in Excel to display easier to read millions uses a custom format to make large values more readable. For instance, 1,200,000 displays as 1.2 M instead—the format ...