18.0k views
2 votes
____Formatting is automatically updated if you change data in the worksheet?

2 Answers

4 votes
Conditional formatting
User Dalmiro Granas
by
6.8k points
7 votes

Answer:

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

Step-by-step 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.

User Ciastek
by
6.3k points