Sum of colored cells

I go in and make them orange. If there is a way i can have excel change them to orange as well as sum the totals inside that would be amazing!

Welcome to the forum, jstebbins. If you want members to help, attach a workbook, not a pdf or image file.

Noticed you have mark the thread "Solved". Could you share your solution with forum members please?

As mentioned in ChemistB's post, you have to provide the reason why certain cells are orange. If there is no logic but merely based on what you choose, then I propose adding a column in G and mark "x" on the rows that you want to filter.

With the entire column F selected, Conditional Formatting formula:=G1="x". If your selection is based on column B with Dept=ACTG, then, CF formula:=B1="ACTG"

I don't see any fields you can SUM.

it has not been solved, i just did not want it dangling there and could not find a way to delete the question. my apologies. i will change it back.

in a nutshell, looking for: if column H = "x" then column F fills ORANGE regardless of data in that cell. F1=sum of cells that are orange in that column.

thanks dave! both of those worked perfectly! i used conditional formatting in column H to highlight the cells orange that has an "x" in them. is there a way that I can make both columns F and H turn orange?

Pefection! You people are amazing!!! Thank you so much!!