Came across something like this before over at mrexcel.com.
In Excel 2003 and earlier this could be accomplished with a lot of VBA.
In 2007, you can countif by color, so you should be able to whip up a
formula or two.

"Neil Pearce" wrote:

Good morning all,

With your help...

I have a workbook that ustilises COUNTCOLORCELLS() to generate the area and
perimeter of a plotted area.

I have another workbook that plots an area using CONDITIONAL FORMATTING
based on the outputs of length and width formulas.

I now wish to combime the two so that the area and perimeter of the
generated plotted shape are calculated. Herein lies the problem...

COUNTCOLORCELLS() will not count cells that are coloured through conditonal
formatting and therefore returns zero at all times.

Is there a way to count cells coloured that are generated from conditional
formatting? Alternatively can I use a method other than conditonal
formatting to plot varying areas- perhaps something along the lines of using
cell referencing... PLOT (A1) to (A+X,1+Y) where X & Y are generated lengths
and widths in two other cells?

You help, as ever, is much appreciated. Thank-you.


Cheers,

Neil