USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How can you delete conditional formatting from selected cells?
|
|
Use Conditional Formatting > Manage rules
|
|
|
Manually format the cells to override any conditional formatting
|
|
|
Use Conditional Formatting > Clear Rules > Clear Rules from Entire sheet
|
|
|
Use Conditional Formatting > Clear Rules > Clear Rules from Selected Cells
|
Explanation:
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.
There is 1 question to complete.