Conditional Formatting
Conditional Formatting helps you automatically apply formatting based on cell content to identify patterns, outliers, and trends in data. It provides the tools you need to highlight important information and compare values visually, making your work more efficient and helping you accomplish tasks with ease. With Conditional Formatting, you can highlight cells by value, text, or date conditions, mark top or bottom items and above or below average values, use data bars, color scales, and icon sets, create custom rules with formulas, rankings, and duplicate values, clear rules from selected cells or an entire worksheet, and manage, edit, delete, or reorder existing rules. Whether you're reviewing key data or handling complex rule setups, Conditional Formatting helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.