Color a cell and a value is automatically assigned to that color. Each color
can be assigned a value by setting it equal to a current cell with the value
in it. To keep a single value for the color, use the $ to keep the letter
and number (column and row) constant.

Example:

You have a list of different choices along the rows, each with different
traits listed in the columns. You can denote which traits are good with by
filling the cell green; and which are bad by filling it with a red color. A
summation function at the end adds up the numerical score of each choice.

First, let's say all the traits are just as important. Greens are worth 5
points while reds are worth zero. In cell A1, you enter a 5. Next, you set
green to equal $A$1. Now color away.

In another example, let's say that different traits carry different value.
One trait may be the cost of a product; another quality; and a third
appearance. A green cost is worth 50, a green quality is 30, and a green
appearance is 5. To set these values, you would have one row as a template
where you enter in these values within their respective trait columns.

Column A is the list of products.
Column B is for price, in Row 2 is entered 50.
Column C is for quality, in Row 2 is entered 30.
Column D is for appearance, in Row 2 is entered 5.

Now, green is set to equal B$2 and a starting point must be provided: in
this case in the B column. Thus, as green is used in C column, it equals
C$2; and in D it equals D$2. Use a summation in a final column to add up the
values and return the winning product.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions