Formula using color of a cell

  • Thread starter Thread starter sa02000
  • Start date Start date
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
 
Back
Top