Count coloured cells

[Nick]

Hi,

Does anyone know of a way i can get Excel to count cells
that have been designated a certain colour?
Note that the colour is not dependant any any conditional
formatting.
Thanks,

Nick

 

[Andy B]

Hi

Have a look here:
http://www.cpearson.com/excel/colors.htm

 

[Hank Scorpio]

Does anyone know of a way i can get Excel to count cells
that have been designated a certain colour?
Note that the colour is not dependant any any conditional
formatting.

Everything you need:

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