need a U.D.F to sum up cells highlighted Red

**James__S** · 04-16-2014, 10:06 AM

Hi

I have a cell range C4:W40 which has values.Cells highlighted RED i need a User defined Function to sum up all values in RED cells.

I am very limited in VBA but appreciate a code if possible

Thanks

**stnkynts** · 04-16-2014, 10:13 AM

If the cells are highlighted red as part of conditional formatting, it can be very challenging. If you are the one that applied the color for each individual cell then this should work:

Please Login or Register  to view this content.

In a cell put "=CountReds(C4:W40)"

**adyteo** · 04-16-2014, 10:16 AM

this is the function (add it to a Module)

Please Login or Register  to view this content.

then, in a cell, type =SumIfRed(here select the range of cells) then press enter

**James__S** · 04-16-2014, 12:02 PM

Title changed:apologies

the cells are highlighted RED through C.F...both functions return 0

Thanks

**James__S** · 04-16-2014, 01:54 PM

I just changed the color of the cell manually and they work....is it not possible to sum if C.F used to color cells?

Thanks

**stnkynts** · 04-16-2014, 04:03 PM

Its not impossible just time consuming. So much so that I doubt anyone here will want to do it. Here is some information on how to do this kind of thing

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

Best of luck.