

Thirdly, the Data Bars has the Gradient Fill, the Solid Fill categories and the More Rules button. Data Bars buttons and Color Scales buttons Excel 2016 Additionally, the Above Average, Below Average and More Rules buttons also are part of Top/Bottom Rules. Secondly, the Top/Bottom Rules comprises of Top Ten Items, Top 10%, Bottom Ten Items, Bottom 10%, buttons etc. Also, the Text that Contains, A Date Occurring, Duplicate Values and More Rules buttons are part of Highlight Cell Rules. Highlight Cell Rules buttons and Top/Bottom Rules button Excelįirstly, the Highlight Cell Rules expands to Greater Than, Less Than, Between, Equal To, buttons etc. Further, the New Rule, the Clear Rules and the Manage Rules are the rest of the buttons.

Also the Data Bars, the Color Scales and the Icon Sets buttons etc are part of this list. The Conditional Formatting button has the Highlight Cell Rules and the Top/Bottom Rules buttons etc. Conditional Formatting commands Styles group MS Excel Also, the buttons going to be described ahead, are of significant importance. So, in this post, all the buttons of this group, shall be the part of our discussion. The Home tab ribbon has this group in Microsoft Excel. Conditional Formatting tools Microsoft Excel 2016įirst of all, we should know that, the Conditional Formatting button is part of the Styles group.
