Using color in formula

[ranebow]

I've color coded numbers in my cells. And now I want to total by color....such as total of all red numbers, total of all blue numbers and total of all green numbers. Is there a way to do this?

 

[SkipVought]

ranebow,

There is no way to use worksheet formulas to determine color.

Did you use some objective criteria to color the cells? If so, you may be able to use a formula that uses similar objective cirteria.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[KenWright]

You can do it with VBA. The following link may give you some idea:-

Summing The Values Of Cells With A Specific Color

http://www.cpearson.com/excel/colors.htm

(You need to scroll down a bit to get to it)

Note though, this does not work if the cells have been formatted using Conditional formatting.

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[byundt]

Chip Pearson also offers VBA functions to count Conditional Formatting colors at

http://www.cpearson.com/excel/CFColors.htm