I create a sum by color function and it worked. My table is conditionally formatted and when I change a value the color changes like it should. My issue is that the ID # of the color is not changing and subsequently my sum function doesn't change.
@horton135 Conditional Formatting doesn't actually change the color attribute of the cell. You will always get the number code for white, event though it displays red. It only works when you apply a "regular" color format to the cell.