![Daily Office Tips by Office ToDo artwork](https://is1-ssl.mzstatic.com/image/thumb/Podcasts113/v4/b1/76/27/b17627f4-9f9f-1e3a-ecd4-dc23e134b898/mza_6931289376909539342.jpg/100x100bb.jpg)
108 Excel | How to clear conditional formatting rules?
Daily Office Tips by Office ToDo
English - December 16, 2010 23:01 - 34 seconds - 5.62 MB Video - ★★★★★ - 2 ratingsTechnology Education How To office daily tips word excel powerpoint Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
Previous Episode: 107 Excel | How to see below average numbers within the list?
Next Episode: 109 Excel | How to compare values visually?
First select the cells or just one cell depending on whether there’s a specific area you wish to clear from rules or you wish for the whole sheet to be free from formatting rules. Next go under Home tab into Styles section and click on the first button from the row called “Conditional Formatting”. From the down-appearing menu click on “Clear Rules” and “Clear Rules from Selected Cells” or “Clear Rules from Entire Sheet” depending on your preference. - Office ToDo