Excel 2010 conditional formatting icon sets based on text
More Icon Sets in Conditional Formatting.
Select one of the color styles of your choice.
Overview of Excel 2010 Sparklines.Fortunately, if youre using iso for windows 8.1 Excel 2010, you arent limited to the default icon sets you can create your own, by mixing and matching from the available icons.Click on the Icon Set and click "Edit Rule".Rob emailed me recently, to ask how to limit the conditional formatting icons to 2 colours only, instead of the 3 or 4 default icon colours.It will show an arrow.You would have to add a column between each month/subtotal in order to achieve this.In the less than box, write.Yellow Fill with Dark Yellow text.
The rule will be activated since the value is lower than the content of the B5 cell.
Now click back on Conditional Format, then Manage Rules.The Data Bars adjust themselves to the new column's length.You can apply many formatting rules at the same time.From the Ribbons' Home tab, select the command Conditional formatting and Data bars and the More Rules options.It enables you to easily compare the values in the range.