Colour cell in value in a list

[Simon]

How do I colour a cell if the value matches a value within
a list called BC?

Also how can I Sum all cells with a certain colour?

 

[J.E. McGimpsey]

To color, see Conditional Formatting in XL Help. One formula:

CF1: =COUNTIF(BC,A1)

Where A1 is the active cell to be formatted.

To Sum:

http://cpearson.com/excel/colors.htm