![]() ![]() In Excel 2010, Microsoft has taken Conditional Formatting which was already very good in Excel 2007 and enhanced it, so that it becomes even more potent. So I decide to swap it out, and I select a yellow dash from the Three Triangles Icon set.Ĭonditional Formatting Data Bars configured to take advantage of all the configurable options available in Excel 2010. Edit one of the rules that you have just created by selecting it and pressing Edit RuleĪs well as being able to choose the Icon Style as you could in Excel 2007, you can also select an individual Icon for each of the different states you want to illustrate (in our case, higher, lower and no change)įor example, I am not a fan of the orange sideways arrow from the Three Arrows (coloured) Icon set.Click on the Conditional Formatting button once more.The Third and I Think the Coolest Improvement to Icon Sets is the Ability to Mix and Match Icons from Different Sets Using the Format Painter in the Clipboard group on the Home tab, change all of your other cells with Icon Sets so that they also hide the results of the formulas.You will notice that the numbers are now suppressed! To quickly do this to your remaining cells containing Icon Sets: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |