Formula using color of a cell

S

sa02000

Is it possible to write a formula which looks up a range of cells fo
certain color and sum the cell with certain color.
So, something of the form

=sumif(B8:B20=certain color condition,B8:B20,0)
can colorindex property of cell be used somehow??

Thanks in advance.
Ja
 

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

Macro Help - Array 3
Recording Macro - Insert Formula 2
Changing font color based on type cell it is. How to do it? 6
CountIf previous cell formula 0
Using cell color in conditional format makes Excel unstable 2
#NAME? on correct formula 4
Shape color index does not match cell color index 4
Cell Background Color Change --> Change Event 5

Top