Conditional ______ changes the appearance of cells based on a set condition.

Conditional ______ changes the appearance of cells based on a set condition.

• A. formatting
• B. validation
• C. coloring
• D. sorting

Answer: (A)

Conditional formatting changes how cells look when a condition is met. It lets you apply visual cues—such as background color, font color, or borders—based on rules you set, so important values stand out or trends are easy to spot. In this case, the blank should be filled with formatting because it refers to altering the cell appearance itself based on a condition. Validation controls what data can be entered, sorting rearranges rows, and coloring is just a visual effect that falls under the broader idea of formatting.

Conditional formatting changes how cells look when a condition is met. It lets you apply visual cues—such as background color, font color, or borders—based on rules you set, so important values stand out or trends are easy to spot. In this case, the blank should be filled with formatting because it refers to altering the cell appearance itself based on a condition. Validation controls what data can be entered, sorting rearranges rows, and coloring is just a visual effect that falls under the broader idea of formatting.