Excel 2010 Bible

Chapter 19: Learning Advanced Charting 479 Plotting mathematical functions with two variables The preceding section describes ho ...

...

481 CHAPTER Visualizing Data Using Conditional Formatting IN THIS CHAPTER An overview of Excel’s conditional formatting feature ...

Part III: Creating Charts and Graphics 482 l (^) Duplicate values: Values that appear more than one time are highlighted. l Word ...

Chapter 20: Visualizing Data Using Conditional Formatting 483 Specifying Conditional Formatting To apply a conditional formattin ...

Part III: Creating Charts and Graphics 484 The formatting suggestions in the drop-down list are just a few of thousands of diffe ...

Chapter 20: Visualizing Data Using Conditional Formatting 485 on text, dates, blanks, nonblanks, and errors. This rule type is v ...

Part III: Creating Charts and Graphics 486 New Feature The data bars feature is improved significantly in Excel 2010. Data bars ...

Chapter 20: Visualizing Data Using Conditional Formatting 487 l (^) Show the bar only (hide the numbers). l Specify Minimum and ...

Part III: Creating Charts and Graphics 488 FIGURE 20.6 A real Excel bar chart (not conditional formatting data bars). A color sc ...

Chapter 20: Visualizing Data Using Conditional Formatting 489 Excel provides four 2-color scale presets and four 3-color scales ...

Part III: Creating Charts and Graphics 490 FIGURE 20.9 This worksheet, which uses color scale conditional formatting, displays a ...

Chapter 20: Visualizing Data Using Conditional Formatting 491 An icon set example Figure 20.10 shows an example that uses an ico ...

Part III: Creating Charts and Graphics 492 FIGURE 20.11 Changing the icon assignment rule. FIGURE 20.12 Using a modified rule an ...

Chapter 20: Visualizing Data Using Conditional Formatting 493 l (^) Up Arrow: When value is >= 5 l Level Arrow: When value &l ...

Part III: Creating Charts and Graphics 494 FIGURE 20.14 Hiding one of the icons makes the table less cluttered. Creating Formula ...

Chapter 20: Visualizing Data Using Conditional Formatting 495 On the CD The companion CD-ROM contains all the examples in this s ...

Part III: Creating Charts and Graphics 496 FIGURE 20.15 Creating a conditional formatting rule based on a formula. Generally, wh ...

Chapter 20: Visualizing Data Using Conditional Formatting 497 Displaying alternate-row shading The conditional formatting formul ...

Part III: Creating Charts and Graphics 498 Figure 20.17 shows an example. For different sized groups, change the 4 to some other ...