Calculate Color Cells

[HotNumbers2001]

Does anyone know how to have excel calculate colors in cells?
This message was edited by HotNumbers2001 on 2002-04-22 11:05

 

[Jay Petrulis]

Hi,

Would you please provide more detail or restate your request? Are you trying to perform a calculation on cells which have a background color, font color, etc?

Thanks,
Jay

 

[HotNumbers2001]

the cells have no numeric values to them. The back ground is colored w/ colors. Need to have a total show up at the bottom of the column to that for example says ....red =3, blue=5... etc..... I hope this is much clearer. This is something that has really stumped me.... Thanks
This message was edited by HotNumbers2001 on 2002-04-22 11:17

 

[Mark W.]

On 2002-04-22 11:16, HotNumbers2001 wrote:
the cells have no numeric values to them. The back ground is colored w/ colors. Need to have a total show up at the bottom of the column to that for example says ....red =3, blue=5... etc..... I hope this is much clearer. This is something that has really stumped me.... Thanks
This message was edited by HotNumbers2001 on 2002-04-22 11:17

Why wouldn't you enter the values 3, 5, etc.?

 

[lenze]

Try this link:

http://www.erlandsendata.no/english/functions/counting/countbycolor.htm

 

[Jack in the UK]

A great pal Dave hawley on ozgrid.com cover this nicley, trust me excellent example


Now days i try to NOT sent posters to others site no other reason than i wil soon have my own, but in this case worth a look see