![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)
107 Excel | How to see below average numbers within the list?
Daily Office Tips by Office ToDo
English - December 15, 2010 23:01 - 28 seconds - 5.02 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: 106 Excel | How to see above average numbers within the list?
Next Episode: 108 Excel | How to clear conditional formatting rules?
First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Top/Bottom Rules” and “Below Average …” From the appearing menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”. - Office ToDo