Conditional formatting is a feature in Microsoft Excel that automatically applies specified formatting to cells that meet certain criteria or conditions. Its primary purpose is to visually emphasize, highlight, or distinguish specific data points, making it easier to analyze data, spot trends, and identify outliers at a glance. For example, a rule can be set to change a cell's background color to red if its value falls below a certain threshold, providing an immediate visual cue.

B. Inserting a new column is a basic worksheet structural command, unrelated to applying formatting based on cell values.
C. Changing the color scheme of a worksheet is managed through Themes, which applies a consistent set of colors to the entire workbook, not to specific cells based on conditions.

1. Microsoft Corporation. (n.d.). Use conditional formatting to highlight information. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f.

Reference Point: The first paragraph states

"Conditional formatting makes it easy to highlight interesting cells or ranges of cells

emphasize unusual values

and visualize data by using data bars

color scales

and icon sets that correspond to specific variations in the data." This directly supports the function of highlighting cells based on a condition.

2. University of Wisconsin-Madison. (n.d.). Excel - Conditional Formatting. Software Training for Students. Retrieved from https://it.wisc.edu/services/software-training-for-students-sts/self-service-training/excel-conditional-formatting/.

Reference Point: The "What is Conditional Formatting?" section states

"Conditional formatting allows you to automatically apply formatting—such as colors

icons

and data bars—to one or more cells based on the cell value." This confirms that the feature's purpose is to apply formats based on a condition.