formula based on format

[James Kendall]

Is there a way to have a formula that is based on a cell colour or based on
the way a cell is formated? I need it to count the number of occurrences
that this happens.

 

[Frank Kabel]

Hi
you'll need VBA. See for an example:
http://cpearson.com/excel/colors.htm

 

[James Kendall]

This is new to me. I have copied it into the VB sheet and placed the
following formula in a cell but it only shows #Name. What am I doing wrong.
I did this to both the countbycolor and the return colorindex value functions
and neither work.

 

[Frank Kabel]

Hi
you also have to put the macro code in a module. See:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[James Kendall]

Thanks it works! And I sure learned a lot today! Thanks again.
James Kendall