finding a cell of a particular color

X

Xavier

Hi,

I would like to make a SUMIF on cells formatted is some ways (font,
background color, character color, ...)

So it would only sum the cells that are written in dark blue for example.

I hav searched but didn't find any function to test that, but I know there
should be one because I can make a 'FIND' on those cells.

Of course I'll have to know the color codes or names ..

Thanks for your help,

Xavier
 
B

Bob Phillips

see response in programming

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top