Is there any way to add, subtract, multiply or divide numbers in a Excel spreadsheet based on the color of the numberin the cell? For example, I have a column of numbers, some black, some red and some blue. I want to have 3 sum cells as the bottom, a red total, a blue total and a black total. Is there any way to do this strictly based on the color of the cell contents? Thanks
