using COUNTIF for cells that are coloured
 

Needing to produce a formula that counts cells that provide a result that is
0 but <3, AND also only those that are shaded Orange in addition to the
values.

Is there a way to count cells based on data as well as formatting, in this
case, cells that are coloured ?

thanks !

using COUNTIF for cells that are coloured
 

See:

http://www.cpearson.com/excel/Colors.aspx

--
Gary''s Student - gsnu200823


"simonfothers" wrote:

Needing to produce a formula that counts cells that provide a result that is
0 but <3, AND also only those that are shaded Orange in addition to the
values.

Is there a way to count cells based on data as well as formatting, in this
case, cells that are coloured ?

thanks !