Question

____Formatting is automatically updated if you change data in the worksheet?

Answer 1

Conditional formatting

Answer 2

Answer:

Conditional  Formatting is automatically updated if you change data in the worksheet

Explanation:

Conditional formatting is useful to present data, add certain color codes to understand data quickly. There are different kinds of conditional formatting such as highlight cells that are greater than the given value, highlight cells that are above average, clear formatting for selected cells etc.

Conditional formatting depends on the data that is entered because it acts on the data. When the data changes the formatting gets changed automatically. You have other conditional formatting cases like less than, equal to, spot duplicate values etc.