View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
only with VBA. See:
http://www.cpearson.com/excel/colors.htm
and
http://www.xldynamic.com/source/xld.ColourCounter.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Mike A." schrieb im Newsbeitrag
...
Is it possible to set up a formula in excel to ingore certain cells

if you
should change the color of that cell to a color.

Example:
=sum(a1:a50)
if cell A25 was blue how can I ignore it so that it is not

calculated?

Mike A.