As far as I'm aware, you can't write code to look at the conditional  colour
of a cell. That colour is the result of the conditional operation and not
an actual property of the cell.

But you don't need to. Simply do the same test in your summing that the
conditional test is doing. In fact, you shouldn't need VBA at all.