Which of the following can be done by using conditional formatting?

Conditional formatting changes how cells look when they meet a rule. You can use it to highlight every cell containing “no.” Calculating sales totals, counting students, and finding an average require formulas or other spreadsheet functions instead.

AI-written and checked against the verified answer.