View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Xavier[_3_] Xavier[_3_] is offline
external usenet poster
 
Posts: 1
Default Test the color of a cell

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