Which path clears all conditional formatting rules from the worksheet?

Which path clears all conditional formatting rules from the worksheet?

• A. Home, Conditional Formatting, Clear Rules, Clear Rules From Entire Sheet.
• B. Home, Conditional Formatting, Clear Rules, Clear Rules From Selected Cells.
• C. Home, Conditional Formatting, Clear Rules, Clear Rules From Active Sheet.
• D. Home, Clear, Clear Rules, Clear Rules From Entire Sheet.

Answer: (C)

Conditional formatting is a set of rules that determine how cells look based on their values. To remove all of them from the worksheet you’re viewing, use the path: Home, Conditional Formatting, Clear Rules, Clear Rules From Active Sheet. This specifically targets the currently active worksheet and deletes every conditional formatting rule on it, so none of those rules will apply to the cells on that sheet anymore. It won’t affect other worksheets in the workbook. Other options would clear rules from the entire sheet or only from the selected cells, which isn’t what you want when you need to remove everything on the current worksheet.

Conditional formatting is a set of rules that determine how cells look based on their values. To remove all of them from the worksheet you’re viewing, use the path: Home, Conditional Formatting, Clear Rules, Clear Rules From Active Sheet. This specifically targets the currently active worksheet and deletes every conditional formatting rule on it, so none of those rules will apply to the cells on that sheet anymore. It won’t affect other worksheets in the workbook. Other options would clear rules from the entire sheet or only from the selected cells, which isn’t what you want when you need to remove everything on the current worksheet.