Calculation based on font color in Excel?

[montejr]

All,
I am working in Excel and am wondering if it is possible to only add cell values together where the number (value) is in a certain font color. Is there a way to write an epxression or do conditional formatting for this?

For example, I have 10 cells with different values. 5 are in blue and 5 in red. Instead of the 11th cell =A1+A2 etc all the way up to A10, can I do it for the 5 cells that have values in red font? When I change a 6th value to red, the sum changes?

Thanks in advance for any help.

Monte

 

[xlhelp]

Not without some VB subroutines.

You should post in forum707

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents

 

[AnotherHiggins]

Is there some logic behind why cells are colored the way they are? If so, then use that same logic in a formula to decide which cells to sum.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.