Assume that, You have a worksheet with conditional formatting from A1:A23 cell. In many case you have to remove conditional formatting from that worksheet like, wrong conditional formatting applied, clear the worksheet for printing etc. To remove conditional formatting you should follow the below steps:
How to remove conditional formatting from worksheet?
Step 1: Select A1:A23 cell that contains the conditional formatting.
Step 2: Click on Home | Conditional Formatting | Manage Rules..
Step 3: Conditional Formatting Rules Manager dialog box will appear like below:
Step 4: As you see that, Duplicate Values conditional formatting rules has already been selected. Just Click the Delete Rule button to delete this conditional formatting rules.
Step 5: Now click on Ok.
How to remove conditional formatting from worksheet?
Step 1: Select A1:A23 cell that contains the conditional formatting.
Step 2: Click on Home | Conditional Formatting | Manage Rules..
Step 3: Conditional Formatting Rules Manager dialog box will appear like below:
Image 1: Conditional Formatting Rules Manager dialog box
Step 4: As you see that, Duplicate Values conditional formatting rules has already been selected. Just Click the Delete Rule button to delete this conditional formatting rules.
Step 5: Now click on Ok.
|||| Please SUBSCRIBE our YouTube Channel ||||
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw