Referencing cell color fill in formulas

Before I even say anything, my skillset is way below most of you guys. I'm here to learn so be easy on me...

I have a table of data where the cells contain financial data and are color filled for different vendors.

First, I need a way to get a percentage of each color fill out of the total (each row), ignoring the data contained in the cells.

Second, I need a way to sum the values and group it into buckets corresponding to the color fill.

If I need to do the color fill and financials in separate cells, that's ok, I just need those two end results.

I imagine its a series of If/Then statements, but again my skillset is pretty lacking in that regard.

Thanks.

Are the color fillings done manually or with conditional formatting based on another cell range?

Color fill will be done manually.

Hmm I'm not sure if it's possible to find certain formatting without using VBA, so let me suggest an alternative solution:

Instead of manually filling the cells with colors, create an additional column in which you type the vendor's name.
With conditional formatting you can now automatically give the financial data cell a color based on the vendor (tell me if you need help with this).
Now you van use the added column to calculate the percentages you want:
=COUNTIF([vendornames range]="[specific vendor name]")/COUNTA[vendornames range]*100

The second problem can now be solved with the SUMIF function:
=SUMIF([vendornames range];[specific vendor name];[summation range]

Please let me know if you get it and if it works

Tricky part with that is there would need to be 16 columns as I have 8 different groups of 2 cells that can each be filled with one of 4 colors...

I was trying to get away from manually typing in each cell and wanted to use the color to indicate the vendor.

ok, so now i have it set up where i can input the vendor and conditional formatting will color fill the cells accordingly.

now, how do i get the same color fill to carry over to the adjacent table where financial data goes? then use that to total the amount of a given color across the row and give what percentage each color is out of the sum all columns in the row?