Conditional formatting automatically applies a format (color, icon, data bar) to cells that meet a condition. It highlights thresholds, duplicates, gaps or trends. Rules recalculate when the data changes and can be based on a formula.
Example
Color red the cells in the Stock column that are below 10.