In Microsoft Excel 365, which of the following is NOT done by Conditional Formatting?

Correct option is A

Conditional Formatting in Microsoft Excel 365 cannot set conditions based on bold text and apply italics on them. Formatting rules are based on cell values, formulas, or specific conditions, not existing formatting like bold or italic.
Important Key Points:
1. What Conditional Formatting Can Do:
· Apply Formats: Highlight cells that meet certain criteria (e.g., greater than, less than, duplicate values).
· Add Multiple Conditions: You can layer multiple rules for complex formatting.
· Use Advanced Options: Apply custom formulas for more dynamic formatting rules.
· Delete Unnecessary Conditions: Manage or remove rules from the Conditional Formatting Rules Manager.
2. What Conditional Formatting Cannot Do:
· It cannot detect existing formatting (e.g., bold or italics) as a condition.
· Formatting rules are applied only to cell values, not the cell’s predefined formatting.
3. Examples of Conditional Formatting:
· Highlight cells greater than a specific value.
· Color-code rows based on a formula (e.g., alternate row colors).
· Apply gradient fills or data bars.
Knowledge Booster:
· Delete a condition if not required: Correct; rules can be removed through the Conditional Formatting Rules Manager.
· Apply font border and pattern formats: Correct; you can customize cell appearance, including borders and fill patterns.
· Add more than one condition: Correct; Excel allows multiple rules to be applied to the same range.