Icon Sets These use icons (e.g., arrows, flags, indicators) to categorize data visually. These are useful for showing trends, progress, or status.

Excel Conditional Formatting Tips TL;DR Key Takeaways : Use Icon Sets to visually represent performance metrics, allowing quick insights into KPIs like sales targets or budget adherence.

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.

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

How to create conditional formatting rules in Excel Once the custom value formats exist, you can apply them using conditional formatting rules. Right now, the format is set to General.

If you want to show negative numbers in red color in Google Sheets, then you can do this using conditional formatting and custom formatting.