Formatting (colors, icons, bars) that applies automatically when cells meet a rule.
Try it with AIConditional formatting changes a cell's appearance based on its value or a formula — highlight duplicates, color a heatmap, flag values above a threshold, or show data bars. The format updates as the data changes.
Yes — choose "Use a formula to determine which cells to format" and enter a TRUE/FALSE formula.