Calculations based on cell color

[imported_unknown]

How do I perform mathematical computation based on the cell color??? The problem lies in the fact that I can color a cell based on a certain value or computation but how do I perform a computation based on color or format of a cell. For example if the cell color is green in a certain range then the cell values should be added. If any of you could be help to me it would be great.

 

[wolverine12]

Sorry, Aladin...

Nevermind, I fixed the problem...I'm an idiot. I had one formula returning an #n/a in that column...that's why it wasn't working.

Problem solved. Thanks again.

Until next time.

 

[Aladin Akyurek]

On 2002-11-20 16:59, wolverine12 wrote:
Thanks for hanging in there...

Ok, I'll give all the details here:

=INDEX('Sheet Name'!P:P,MATCH($A311,'Sheet Name'!$B:$B,0),0)
The returned result is a dollar value and the cell(s)has a coloured background.

Later I use:
=SUMPRODUCT((ExtCell("backgroundcolor",Range,1)=Color Value)*(Range)
I get #n/a returned unless I replace the formula (first one above) with the actual values.

I hope that makes it more clear.

The exhibit below shows that formulas in the range with colored cells do not have any adverse effect...

HGroveExtCell.xls
	A	B	C	D	E
1
2	a	9		3
3	b	12		33
4		40
5		12
6
7
8	LookupTable
9	a	9
10	b	12
11	c	21
12
Sheet2

=SUMPRODUCT((ExtCell("backgroundcolor",Range,1)=Color Value)*(Range))

where Color value must be an integer like 3 (for red) or a cell ref housing an integer. Otherwise, I don't see why you'd have problems with it.

 

[Aladin Akyurek]

On 2002-11-20 17:12, wolverine12 wrote:
Sorry, Aladin...

Nevermind, I fixed the problem...I'm an idiot. I had one formula returning an #n/a in that column...that's why it wasn't working.

Problem solved. Thanks again.

Until next time.

Yes, that's another reason...