FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -To remove conditional formatting from specific cells, select the cells, click the Quick Analysis button, and click Clear Format. To remove all conditional formatting from the entire worksheet, click the Conditional Formatting button on the HOME tab, point to Clear Rules, and click Clear Rules from Entire Sheet.

Detailed explanation-2: -On the Home tab, in the Font group, click Clear All Formatting.

Detailed explanation-3: -Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.

Detailed explanation-4: -Conditional Formatting rules can be managed and removed using the Clear Rules and Manage Rules features. Here is the Clear Rules part of the conditional formatting menu: You can remove all the rules from a selected range of cells or from the entire spreadsheet using the Clear Rules menu options.