Displaying Relative Values
Some people can glance at a column and create a visual image of the relationships among the numbers. However, if all you see is a bunch of numbers, you can add displays that indicate the relationships of the numbers to each other. For example, you can include bars that show the relative value of each number, you can color-code entries by their ranking, and you can even use icons to indicate the relative values.
Show the Relative Value
Select the cells you want to include. Each value will be compared with all the other data in the selection.On the Home tab, click the Conditional Formatting button, point to the type of indicator ...
Get 2007 Microsoft® Office System Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
