Can excel sum certain cells according to font color?

i.e. cash back expenses listed in red - summed to cell E4
credit card purchases listed in blue - sum to cell F4

the user manipulates the font color during input. But all values are listed
in a Mon-Fri G1-K1 area