In your first cell type in e.g.
r for red
g for green

Then do a conditional format on cell 1 to say if cell = r then format it
font red & pattern red.... then add 2nd condition if cell = g then
format it font green & pattern green.. this will change it a particular
colour.

Then in your 2nd cell type in = the 1st cell. this will then have either
a letter r or g appearing. Then just do exactly the same conditional format
conditions as you did in 1st cell.

To add up all the r's do a sumif( ) = r



"Phillip Bruce" wrote:

How can I format a cell based on the color fill of another cell?

Also, how could I add up all the cells that contain a certain color fill?