Conditional formatting highlights cells that meet a rule — top values, duplicates, dates due, or anything a formula can test — so patterns jump out.
Do it with AI insteadSelect the range
Highlight the cells you want to format.
Open Conditional Formatting
Home ▸ Conditional Formatting, then pick a rule type.
Set the rule and format
Choose the condition (e.g. greater than) and the fill/font color.
Yes — use a formula rule with a column-locked reference like =$C2="Done" applied to the whole row range.