Calculations Based on Format

[Guest]

Is there a way to calculate cells based on their format? In other words if a
cell is formatted with say Red it is counted/summed, if Blue it is not??

 

[Gord Dibben]

See Chip Pearson's site for methods to count/sum by color.

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


Gord Dibben MS Excel MVP

 

[davesexcel]

Here are two sites that have the function codes to count coloured
cells:

http://www.xldynamic.com/source/xld.ColourCounter.html#code

and here


http://www.mrexcel.com/td0106.html