When I do this the Value is set to zero, overriding the previous value, which is why I do it first. I am going to leave it set to the default.įor the green icon, I set the Type of value to Number. You can apply it to specific cells, tables, PivotTables, and worksheets.įor example, to quickly conditionally format these selected cells, you can use a Quick Analysis option or an option on the Conditional Formatting button in the ribbon.īut if you want more control over what type of, and when conditional formatting applies, click New Rule, select a Rule Type (such as Format all cells based on their values), select a Format Style (such as Icon Sets), select the Icon Style that you want (icon sets range from 3 to 5 icons and numerous icon styles). In this course, we’ll go over how to get that much more out of conditional formatting. See the course summary at the end of this course for a link. In the course, Use conditional formatting, we covered the basics of conditional formatting.Ĭonditional formatting provides visual cues to help you make sense of your data.įor example, it’ll clearly show highs and lows, or other data trends based on the criteria you specify.
0 Comments
Leave a Reply. |