Excel - formula to calculate colored fill cells within a range wi.

G

Guest

I am making a report that is by province and have highlighted all the cell in
the coloum in the color fill that is assigned to that province. I want to
do a formula that will add all the colored cells for each province without
having to manually go and select the colored cells for the answer...is there
a way to have the formula reconqnize the color only for the answer for within
the range??? Would save a lot of time....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Sorting / Filtering Colored Cells 1
count colored cells in excel 5
How to Color a Cell Based on a Range of Cells with Colors 1
Excel VBA 1
Converting colored cells to numbers- is there a formula? 1
Color fill cells to be added into totals 1
How to blank the colored cells? 0
Is there a way to count colored cells that are conditionally formatted? 3

Top