Summing a range depending on cell background colour

G

Guest

I would like to know how to sum a range depending on cell background colour
so if range was background colour red for example it would sum all the red
shaded cells that have numbers in them. Any help appreciated
 
B

Bob Phillips

At 15:12, an hour before this thread, in your previous post, you said you
had got it working. What's up?

--
HTH

Bob Phillips

"Re: Inserting an option button in Word"
 

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

Summing cells by background colour 6
Summing a range if a certain background colour 7
assigning different background colours in a range 2
Conditional Formatting VBA with formula to find string 3
Formatting the background of unlocked cells 5
Combo box background colour 1
Note related background color of a cell 4
copy rows based on cell colour by conditional formating 8

Top