Using color to ignore cells in a formula?????
 

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.

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.

You would need to make a UDF so it's not built in

http://www.cpearson.com/excel/colors.htm

Regards,

Peo Sjoblom


"Mike A." wrote:

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.