Conditional formatting

Excel glossary definition

Rules that change a cell's appearance based on its value.

Definition

Apply colours, icons, or data bars based on rules (greater than, top 10, formula-based, duplicates, etc.) without changing the underlying value.

Back to Excel glossary